Home |
Search |
Today's Posts |
#1
|
|||
|
|||
equation that adds hours as scheduled. 11:00 to 5:00 +6hrs. res.
I sometimes do the employee schedule when my boss is away. The current
schedule is done in excel and is basically a shell with no calculating. I need a equation for excel that figures Hours worked, for weekly calculation of payroll. would be easier if excel could compute 11:45 to 5:15 ='s 5.5 hours. Can it or do I need to look to another program. |
#2
|
|||
|
|||
Hi!
A1 = 11:45 AM B1 = 5:15 PM =(B1-A1)*24 = 5.5 If the times can span past midnight: A1 = 11:45 PM B1 = 5:15 AM =(B1-A1+(A1B1))*24 = 5.5 Biff -----Original Message----- I sometimes do the employee schedule when my boss is away. The current schedule is done in excel and is basically a shell with no calculating. I need a equation for excel that figures Hours worked, for weekly calculation of payroll. would be easier if excel could compute 11:45 to 5:15 ='s 5.5 hours. Can it or do I need to look to another program. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |