How do i get time in excel to calculate time between 20:00-03:45

[Biff]

My best guess at what you want:

=B1-A1+(B1<A1)

Biff

 

[JE McGimpsey]

one way:

A1: 20:00
B1: 03:45
C1: =MOD(B1-A1,1)

Format C1 as time.

"peter" <[email protected]> wrote: