Difference Between Two Times

[ANYX]

I am calculating the difference between times. C20 reflects the start time
11:55 PM and E20 reflects the end time 12:15 AM. How do I show the time
difference in minutes?

 

[Mike H]

Try this

=E20-C20+(E20<C20)

Apply a custom format of [mm]


Mike

 

[Mike H]

Hi,

One way
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

or

select the date then

Data|Text to columns - Next - Next - Select Date - YMD

Finish

Mike

 

[David Biddulph]

=MOD(E20-C20,1)*24*60 and format as General or Number

 

[Mike H]

oops wrong thread

Hi,

One way
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

or

select the date then

Data|Text to columns - Next - Next - Select Date - YMD

Finish

Mike

 

[Fred Smith]

And one more:
=mod(e20-c20,1)

Regards,
Fred.