Calculate minutes from timecard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

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

Calculate After hours 3
Array using MIN 3
how can i subtract time from two different date? 1
Time format shows default of 12:00 AM 6
Count entries in the column translating to minutes. 5
Extract first and last login time for each day only 6
Ignore text in timecard calculation 1
Converting hours to minutes 5

Back
Top