![]() |
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 |
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 |
All times are GMT +1. The time now is 07:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com