Excel 2007 elapsed time help needed

[peterv6]

I need to create a timesheet for work. It's easy if all hours are worked on the same day. What I need, however, is a time format and equation that will calculate the time worked if the time spans midnight.
Example:
Start: 6pm
End: 12am the next day.
Total should be 8 hours.

Can someone please help me figure this our?

 

[mole999]

> https://www.mrexcel.com/forum/excel-questions/341459-calculating-difference-between-two-times.html

 

[snjpverma]

Try this
B1-A1+1