Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I show schedule 11pm to 8 am in Excel?
|
#2
|
|||
|
|||
How do I show schedule 11pm to 8 am in Excel?
You need to be much more specific. Post your question in the body
of your message, not the subject line. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Frank" wrote in message ... |
#3
|
|||
|
|||
How do I show schedule 11pm to 8 am in Excel?
I'm writing a staff schedule in Excel, showing not only start and end times
but calculating hours worked by each employee but totally hours daily and weekly. Having trouble with shift that starts at 11:00 p.m. on one day and ends at 8:00 a.m. on the next day. Thx, Frank "Chip Pearson" wrote: You need to be much more specific. Post your question in the body of your message, not the subject line. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Frank" wrote in message ... |
#4
|
|||
|
|||
How do I show schedule 11pm to 8 am in Excel?
Hi Frank,
Try =mod(end-start,1) Rgds FxM Frank wrote: I'm writing a staff schedule in Excel, showing not only start and end times but calculating hours worked by each employee but totally hours daily and weekly. Having trouble with shift that starts at 11:00 p.m. on one day and ends at 8:00 a.m. on the next day. Thx, Frank "Chip Pearson" wrote: You need to be much more specific. Post your question in the body of your message, not the subject line. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Frank" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Pivot tables - how to "show pages" | Excel Discussion (Misc queries) | |||
How do I show my menu bar in Excel? | Excel Discussion (Misc queries) | |||
Export/link a course schedule from excel into calendar format | Excel Discussion (Misc queries) | |||
how do i get excel to show mm/yy | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |