Time format

[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

 

[Peo Sjoblom]

Try

=MOD(end_time-start_time,1)

 

[Andre Croteau]

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

B1-A1+(B1<A1)

André