Calculate minutes from timecard

A

achapman

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!
 
B

Bernard Liengme

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
 
Top