Calculate minutes from timecard
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! |
Calculate minutes from timecard
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! |
All times are GMT +1. The time now is 07:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com