Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Time Worked - How to Calculate
Hello - I am new to the Office Discussion Groups and am despartely looking
for some help. I have data from a time management system that reports start time and end time. I need to calculate what the actual time worked was, which is the difference between the two. The data is displayed as: 10:45:00 and 6:57:00, each being in a separate cell. In this particular example, it is saying 10:45am to 6:57pm. Can anyone help me by providing a formula that would give me the total time worked? I prefer to have it in minutes if possible. Thanks for your support. -- Amy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Time Worked - How to Calculate
A1=Start, B1=Finish
=(B1-A1)*1440 Or =MOD(B1-A1,1)*1440 The latter allows for times over midnight i.e finish < start Format cells as general "Amy" wrote: Hello - I am new to the Office Discussion Groups and am despartely looking for some help. I have data from a time management system that reports start time and end time. I need to calculate what the actual time worked was, which is the difference between the two. The data is displayed as: 10:45:00 and 6:57:00, each being in a separate cell. In this particular example, it is saying 10:45am to 6:57pm. Can anyone help me by providing a formula that would give me the total time worked? I prefer to have it in minutes if possible. Thanks for your support. -- Amy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Time Worked - How to Calculate
Thank you so much for your help.
-- Amy "Amy" wrote: Hello - I am new to the Office Discussion Groups and am despartely looking for some help. I have data from a time management system that reports start time and end time. I need to calculate what the actual time worked was, which is the difference between the two. The data is displayed as: 10:45:00 and 6:57:00, each being in a separate cell. In this particular example, it is saying 10:45am to 6:57pm. Can anyone help me by providing a formula that would give me the total time worked? I prefer to have it in minutes if possible. Thanks for your support. -- Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate total service time in excel | Excel Discussion (Misc queries) | |||
Total TIme worked | Excel Worksheet Functions | |||
How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
Getting a total of hours & mins worked per week | New Users to Excel | |||
i need to calculate the total time from a start time to and end t. | Excel Discussion (Misc queries) |