Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the the diffrence between 2 Dates and time
I am trying to create a formula that calculates the diffrence beween the date
and the time. I.e result would be 3d 10m ot 3d 10m30s. Can anyone help?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the the diffrence between 2 Dates and time
How about
=INT(A7-A6)&"d "&TEXT(MOD((A7-A6),1),"h:mm:ss") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LKWP" wrote in message ... I am trying to create a formula that calculates the diffrence beween the date and the time. I.e result would be 3d 10m ot 3d 10m30s. Can anyone help?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the the diffrence between 2 Dates and time
Are your date/time values combined in one cell, or separate cells for
date and for time? Essentially, you just need to subtract the smaller (earlier) date/time from the larger (later) date/time, and then apply a custom format to the result as you require it, but you will need to account for hours as well as minutes and seconds. Hope this helps. Pete On Jul 2, 1:18*pm, LKWP wrote: I am trying to create a formula that calculates the diffrence beween the date and the time. I.e result would be 3d 10m ot 3d 10m30s. Can anyone help?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time diffrence with 24 hour clock | Excel Worksheet Functions | |||
Please Help Calculate Time Between 2 different Dates | Excel Discussion (Misc queries) | |||
Calculate Time To Respond from Dates | Excel Discussion (Misc queries) | |||
Cells with time format and calculating the diffrence | New Users to Excel | |||
How to calculate time between two dates? | Setting up and Configuration of Excel |