Difference Between Two Times
 

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?

Difference Between Two Times
 

Try this

=E20-C20+(E20<C20)

Apply a custom format of [mm]


Mike

"ANYX" wrote:

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?

Difference Between Two Times
 

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

"ANYX" wrote:

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?

Difference Between Two Times
 

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

ANYX wrote:
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?

Difference Between Two Times
 

oops wrong thread

"Mike H" wrote:

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

"ANYX" wrote:

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?

Difference Between Two Times
 

And one mo
=mod(e20-c20,1)

Regards,
Fred.

"ANYX" wrote in message
...
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?