With the four times in A1:D1 use
=(B1-A1)+(B1<A1)+(D1-C1)+(D1<C1)
The second and fourth term allows for an intervening midnight
But formula will no work if there are two midnight in a shift (unlikely?)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"achapman" wrote in message
...
I have to manually calculate the time someone has worked using timecards.
Is
there a formula where I can plug in the time and get the answer? I saw
one
question where this was posted but it didn't help. For example, he worked
from 7:40 AM - 11:37 AM and then came back to work from 12:03 PM to 4:59
PM.
Thx!