| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the difference in date/time formatted cells
I need to know how to find the difference in time in two cells with a
date/time format of 05/01 04:30 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the difference in date/time formatted cells
Hi,
With this in A1 and b1 15/05/2010 10:00 16/05/2010 11:30 formula =B1-A1 Format the formula cell as dd hh:mm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Longhorn1972" wrote: I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the difference in date/time formatted cells
Just subtract the two cells and format the formula cell as custom [h]: mm
=A2-A1 Regards, Per "Longhorn1972" skrev i meddelelsen ... I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the difference in date/time formatted cells
OK until you get beyond 31 days, I think you'll find.
-- David Biddulph "Mike H" wrote in message ... Hi, With this in A1 and b1 15/05/2010 10:00 16/05/2010 11:30 formula =B1-A1 Format the formula cell as dd hh:mm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Longhorn1972" wrote: I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the difference in date/time formatted cells
Yes, absolutely correct David. I had this mindset of 1 day and a few hours.
Thanks for the correction. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "David Biddulph" wrote: OK until you get beyond 31 days, I think you'll find. -- David Biddulph "Mike H" wrote in message ... Hi, With this in A1 and b1 15/05/2010 10:00 16/05/2010 11:30 formula =B1-A1 Format the formula cell as dd hh:mm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Longhorn1972" wrote: I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30 . |
|
#6
|
|||
|
|||
Quote:
B1 has 10/10/2010 12:02:00 PM this formulae ="days- "&TRUNC(B1-A1,0)&" hours-"&(((B1-A1)-TRUNC(B1-A1,0))*24) gives u the result as: days- 282 hours- 6.94999999995343 all the best
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate time difference in hh:mm:ss | Excel Discussion (Misc queries) | |||
| Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
| Calculate from time formatted cell | Excel Worksheet Functions | |||
| Calculate time difference between cells | Excel Discussion (Misc queries) | |||
| Subtracting Cells formatted with Date AND Time to get hours? | Excel Discussion (Misc queries) | |||
Linear Mode
