Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate difference between two times | Excel Worksheet Functions | |||
Calculate difference between 2 date and times with average | Excel Discussion (Misc queries) | |||
Calculate the difference two times | Excel Discussion (Misc queries) | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
How can I calculate the difference between times without using th. | Excel Worksheet Functions |