Date display in days:hh:mm format

[system]

Suppose the difference between two dates using daysbetween function is -1164.6. i need to display it in days:hours:minutes format. Kindly help.

---

rmarthini (BOB member since 2012-12-26)

[system]

Hi,

This old topic can get you started:

Convert minutes to Weeks/Days/Hours/Minutes

Hey guys, I have a column in the SQL Server database which tells me the number of minutes between 2 dates. Could anyone tell me how to convert that to the format; 3 Years, 2 Months, 1 Week, 2 Days, 13 Hours, 52 Minutes. I get lost very quickly. Cheers, Stuart stuartgmilton (BOB member since 2003-01-30)

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Create this [Time Btw]=Abs([Time Btw Start and End]) and then create

=FormatNumber (Floor([Time Btw]/86400);"0")
+ ":" 
+ FormatNumber (Floor(Mod([Time Btw] ;86400)/3600) ;"00") 
+ ":" 
+ FormatNumber (Floor(Mod(Mod([Time Btw] ;86400) ;3600)/60) ;"00") + ":" 
+ FormatNumber (Mod(Mod(Mod([Time Btw];86400) ;3600) ;60) ;"00")

[Moderator Edit: Added code formatting - Andreas]

---

buggi (BOB member since 2006-01-27)