| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I set up a time card format in Excel
I am trying to construct a worksheet that will allow me to figure out my
hours worked, regular time and overtime in seperate columns. I have the following headings: Start End Hours Reg Hours Overtime Total F 1 8:00 AM 9:00 PM 13:00 F = Friday 1 = 1st of the month I want to know hot to set it up to figure out the Reg Hours column, Overtime = anything after 8 hours and the total should be the same number as in the hours column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting to Time Format | Excel Discussion (Misc queries) | |||
| Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
| Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
Threaded Mode
