Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok. Calculating a time sheet. Entries are as follows
Columns DEFG Have Time In, Time Out, Time In, Time Out headings. I calculated total hours by: =(E5-D5)+(G5-F5) Have cell formatted as h:mm so the time displays actual hours and minutes worked ex: 8:13 (8 Hours/13 Minutes). Now to that number I want to add additional time such as Sick Leave 1 (hour), 1.5, .25. How can I calculate. If necessary I probably can divide the additional time entrys into two cells with hours in one and minutes in another. If you can help with calculation and cell formatting, I would appreciate it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Calculation | Excel Discussion (Misc queries) | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |