kevinonearth
Member
Hi,
I've a spread sheet which is meant to calculate the amount of overtime hours an employee has worked up over a year.
The formula works fine until overtime hours worked exceeds 24 hours.
For example:
current overtime hours are: 22:00
Employee works another: 03:00
excel reverts to 24 hours format giving: 01:00
I want it to return: 25:00
how do I reset excel to do what I want it to do?
I've a spread sheet which is meant to calculate the amount of overtime hours an employee has worked up over a year.
The formula works fine until overtime hours worked exceeds 24 hours.
For example:
current overtime hours are: 22:00
Employee works another: 03:00
excel reverts to 24 hours format giving: 01:00
I want it to return: 25:00
how do I reset excel to do what I want it to do?