Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the formula to calculate someones time worked
I would like to use excel spreadsheet and calculate a simple payroll time
card. A person start time to work is 10:15 pm (cell A 1) and end time is 2am (cell B 1). What would be the formula for cell c1 to calculate the total number of hours worked which would be 3 3/4 hours total worked. . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the formula to calculate someones time worked
In order to calculate the time correctly, the cells must be a date-time
field, (especially if you are calculating times on two different days. The formula would be (assuming start date-time is in A1 and end date-time is in B1) : =(B1-A1)*24 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the formula to calculate someones time worked
=B1-A1
if you want in time format (3:45) =(B1-A1)*24 if you want it in decimal time format (3.75) -- HTH RP (remove nothere from the email address if mailing direct) "deusy" wrote in message ... I would like to use excel spreadsheet and calculate a simple payroll time card. A person start time to work is 10:15 pm (cell A 1) and end time is 2am (cell B 1). What would be the formula for cell c1 to calculate the total number of hours worked which would be 3 3/4 hours total worked. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write the formula to calculate someones time worked
=MOD(B1-A1,1)
or =B1-A1+(A1B1) -- Regards, Peo Sjoblom "deusy" wrote in message ... I would like to use excel spreadsheet and calculate a simple payroll time card. A person start time to work is 10:15 pm (cell A 1) and end time is 2am (cell B 1). What would be the formula for cell c1 to calculate the total number of hours worked which would be 3 3/4 hours total worked. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting time worked to dollars earned. | New Users to Excel | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) |