Help on DateTime Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First of all, I'd like to thank all.
I have this formula which works well

CDate([Delivery Date] & " " & [Delivery Time])-CDate([Arrival Date] & " " &
[Arrival Time])

I get a values as double precision numbers like so:
01/01/2005 13:00 01/02/2005 14:05 "1.04513888889051"
My question:

I want to format the Decimal on "TOP" (1.04513888889051) as: X day X hours
X minutes?

I TRIED THE DATE2DIFF MODULE, I CAN"T GET IT TO WORK. Are there any options?

Any thoughts, thanks again.
 
In your previous thread where you were pursuing this, I suggested:
You should be able to just add the time to the date:
=Diff2Dates("hns",[Delivery Date] + [Delivery Time], [Arrival Date]+
[Arrival Time])

Did this work or did you get an error?
 
This is old, everything worked, thanks again

Duane Hookom said:
In your previous thread where you were pursuing this, I suggested:
You should be able to just add the time to the date:
=Diff2Dates("hns",[Delivery Date] + [Delivery Time], [Arrival Date]+
[Arrival Time])

Did this work or did you get an error?

--
Duane Hookom
MS Access MVP
--

bladelock said:
First of all, I'd like to thank all.
I have this formula which works well

CDate([Delivery Date] & " " & [Delivery Time])-CDate([Arrival Date] & " "
&
[Arrival Time])

I get a values as double precision numbers like so:
01/01/2005 13:00 01/02/2005 14:05 "1.04513888889051"
My question:

I want to format the Decimal on "TOP" (1.04513888889051) as: X day X
hours
X minutes?

I TRIED THE DATE2DIFF MODULE, I CAN"T GET IT TO WORK. Are there any
options?

Any thoughts, thanks again.
Click to expand...
Click to expand...
 
Back
Top