Calculate Difference in Times with Considering Date
To get the interval in minutes between 2 properly formatted dates/times use:-
=((B1-A1)*24)*60 where B1 is the later time.
However, I've never seen a time format like this what are the last 3 digits
meant to denote?
2007-05-20 01:42:31:593
Mike
"CB" wrote:
A B
A1 start time B1 end time
A2 007-05-19 13:48:49:295 B2 2007-05-20 01:42:31:593
Using The Date time format above I would like to get the difference in
Minutes between the strart and end time , Can you help me with a formula that
can handle this. I am using excel 2002 .
Thanks
|