| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate minutes when given two times? | Excel Worksheet Functions | |||
| how to calculate the hours and minutes in excel | Excel Discussion (Misc queries) | |||
| Calculate hour and minutes worked each day | New Users to Excel | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
Linear Mode
