time-clock calculation
I am attempting to do a calculation for hours worked using the 24-hour format
but have run into a problem. A simple minus calculation such as (C5-A5)
does not yield an accurate calculation if the time value for A5 is greater
than C5. Can you suggest a format/formula to use is my punch out time is
17:00pm and punch in time is 05:00am?
|