If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink to specific sheet in Excel Web File | jd17 | Links and Linking | 0 | December 8th, 2004 09:03 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |
Time Sheet calculations | John Tibbotts | Worksheet Functions | 1 | December 7th, 2003 05:21 AM |
Unable to access excel sheet on server from excel | Bob Fisher | Links and Linking | 0 | September 19th, 2003 05:18 PM |