ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Timesheet (https://www.excelbanter.com/excel-worksheet-functions/84744-timesheet.html)

MyKidsBank

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

Biff

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