Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time card excel sheet
I currently use excel to track over 70 employees but I
need either a formula for the following scenrio. In 7:45am out 12:00am in 1:25pm out 6:00pm then have a total of hours in one cell for the whole day. Right now I am enter the time but in military time. I did find an excel template to use but the formla is not right. |
#2
|
|||
|
|||
Try this formula assuming that:
D8=In Time, E8=Out Time, F8=In Time, G8=Out Time Enter time using AM and PM the formula is: =IF(E8-D8+G8-F8<=0,0,E8-D8+G8-F8) Dan "Nancy Comello" wrote in message ... I currently use excel to track over 70 employees but I need either a formula for the following scenrio. In 7:45am out 12:00am in 1:25pm out 6:00pm then have a total of hours in one cell for the whole day. Right now I am enter the time but in military time. I did find an excel template to use but the formla is not right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
hyperlink to specific sheet in excel | Excel Worksheet Functions | |||
Time sheet set up specifically | New Users to Excel | |||
Adding time in Excel | Excel Worksheet Functions |