Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Time Sheet
Hi, My name is Chuck and I am trying to write a spreadsheet to be used as a daily timesheet. The way it is set is: c6 is Time In, d6 Time out for Lunch, e6 Time in from lunch and f6 is Time Out. The formula I am using for total time is (d6-c6)+(f6-e6) I need to round this to the 1/4 hour. Any help is appreciated. Chuck -- CRobey4393 ------------------------------------------------------------------------ CRobey4393's Profile: http://www.excelforum.com/member.php...o&userid=28257 View this thread: http://www.excelforum.com/showthread...hreadid=478463 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet | Excel Discussion (Misc queries) | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
time sheet calculations | Excel Worksheet Functions | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Time Sheet calculations | Excel Worksheet Functions |