time-clock calculation

G

Guest

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

Sandy Mann

Assuming that the 05:00 is the following morning try

=C5-A5+(C5<A5)

or


=MOD(C5-A5,1)


HTH

Sandy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

currency and time calculation 1
TIME CALCULATION 5
Time difference calculation 2
time-clock calculation 3
Time attendance calculation problem 1
time calculation 7
Show time as a negative figure 3
How enter time DURATIONS mm:ss (not clock times), then sum? 1

Top