time

D

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?
 
T

Toppers

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