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?
|