time: when my overtime hours reach more than 24,

[dve]

I am trying to set up a timesheet and find that when my overtime hours reach
more than 24, they automatically change to show the difference to the
24hours. e.g. 27 hours shows as 3 hours. How can I stop this from happening?

[Toppers]

Set format as [h]:mm rather than hh:mm. This stops Excel from "rolling over"
the day.

"dve" wrote:

> I am trying to set up a timesheet and find that when my overtime hours reach
> more than 24, they automatically change to show the difference to the
> 24hours. e.g. 27 hours shows as 3 hours. How can I stop this from happening?