Calculate Difference in Times with Considering Date
 

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

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

Calculate Difference in Times with Considering Date
 

XL times are stored as fractional days (i.e., 1 = 24 hours = 24*60
minutes), so one way:

=(B1-A1)*1440

Format as General, or another number format.

In article ,
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 .

Calculate Difference in Times with Considering Date
 

This won't work with the the date number format I indicated - can you help me
? How can I format this date and time to usable format?

"JE McGimpsey" wrote:

XL times are stored as fractional days (i.e., 1 = 24 hours = 24*60
minutes), so one way:

=(B1-A1)*1440

Format as General, or another number format.

In article ,
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 .

Calculate Difference in Times with Considering Date
 

One way:

=(SUBSTITUTE(B2,":",".",3)-SUBSTITUTE(A2,":",".",3))*1440

In article ,
CB wrote:

This won't work with the the date number format I indicated - can you help me
? How can I format this date and time to usable format?

"JE McGimpsey" wrote:

XL times are stored as fractional days (i.e., 1 = 24 hours = 24*60
minutes), so one way:

=(B1-A1)*1440

Format as General, or another number format.

In article ,
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 .