Time format

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Hello,

I have a spreadsheet with 2 Time columns. All of my
formuals work except on over night shifts. So when I add
them I get 32 hours on a 23:00 - 07:00 shift when I really
want 8 hours. Any suggestions?

Thanks,

Denise
 
I found that this formula woks well for any possibility:
where A1 has starting time, and B1 finishing time

B1-A1+(B1<A1)

André
 
Back
Top