How do I show schedule 11pm to 8 am in Excel?
 

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
...

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
...

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
...