| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet
Hello,
I need a timesheet that will allow daily time input that rolls over to the next day, i.e., 22:00 in the evening to 06:00 the next morning (new day)... Thanks... John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Timesheet
Hi!
A1 = 22:00 B1 = 6:00 =B1-A1+(B1<A1) Format the cell as h:mm for a return of 8:00. =(B1-A1+(B1<A1))*24 Format the cell as GENERAL for a return of 8. Biff "MyKidsBank" wrote in message ... Hello, I need a timesheet that will allow daily time input that rolls over to the next day, i.e., 22:00 in the evening to 06:00 the next morning (new day)... Thanks... John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Timesheet Help. Rounding to the nearest 1/4 | Excel Worksheet Functions | |||
| How do I calculate an employee timesheet in Excel? | Excel Worksheet Functions | |||
| Timesheet help | Excel Worksheet Functions | |||
| overtime on timesheet | Excel Worksheet Functions | |||
| timesheet with running total of overtime | Excel Worksheet Functions | |||
Linear Mode
