Time calculations

Post useful calculations you have come up with. List the variables and formulas you have created.

Time calculations

Postby mwm » Mon Oct 13, 2008 4:12 pm

The following sets of calculations convert from a time value in a single unit to the canonical representtation as a number of days, hours, minutes and seconds.

Seconds to DHMS

Variables

Seconds = 90600.000000
Minimum value = 0.000000
Maximum value = 0.000000
Prefix =
Suffix =
Display to 0 decimal places
Results

Days = 1.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = floor(Seconds/86400)
Hours = 1.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Seconds/3600,24)
Minutes = 10.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Seconds/60,60)
Seconds = 0.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Seconds,60)
Notes

Minutes to DHMS

Variables

Minutes = 1625.000000
Minimum value = 0.000000
Maximum value = 0.000000
Prefix =
Suffix =
Display to 3 decimal places
Results

Days = 1.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = floor(Minutes/1440)
Hours = 3.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Minutes/60,24)
Minutes = 5.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Minutes,60)
Seconds = 0.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Minutes*60,60)
Notes

Hours to DHMS

Variables

Hours = 8.540000
Minimum value = 0.000000
Maximum value = 0.000000
Prefix =
Suffix =
Display to 6 decimal places
Results

Days = 0.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = floor(Hours/24)
Hours = 8.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Hours,24)
Minutes = 32.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Hours*60,60)
Seconds = 23.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Hours*3600,60)
Notes

Days to DHMS

Variables

Days = 0.110000
Minimum value = 0.000000
Maximum value = 60.000000
Prefix =
Suffix =
Display to 8 decimal places
Results

Days = 0.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = floor(Days)
Hours = 2.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Days*24,24)
Minutes = 38.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Days*1440,60)
Seconds = 24.000000
Prefix =
Suffix =
Display to 0 decimal places
Formula = mod(Days*86400,60)
Notes
mwm
 
Posts: 15
Joined: Mon Oct 13, 2008 3:57 pm

Return to Swap calculations

Who is online

Users browsing this forum: No registered users and 2 guests

cron