mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > mmDHMS, Number to Time

Business Formulas

mmDHMS, Number to Time

Category: Utility

The mmDHMS function transforms a number in a text string showing the time elapsed from the zero starting point in Days, Hours, Minutes, and Seconds. For instance:

  • mmDHMS(1) = 1:00:00, equals one hour
  • mmDHMS(0.5) = 30:00, equals 30 minutes
The mmDHMS function is used by the MM4XL queuing functions. It can be very useful for computing the time between events, such as the time elapsed between the entry of two visitors in a website, just to mention one case.

Syntax

mmDHMS(number)

Number A number to transform in a time string showing Days, Hours, Minutes, and Seconds

Example

See example file Business Formulas.xls, sheet mmDHMS.

Business analysis formulas for Excel. Marketing tool for professionals

Note:

Related functions
  • mmMD1
  • mmMG1
  • mmMMS
  • mmMMSP
  • mmMMSQ
  • mmPERTSD
  • mmPERTT
  • mmPERTVAR
  • mmCODING
  • mmDBAVG
  • mmDBCOUNT
  • mmDBSUM
Related MM4XL software tools
  • CrossTab
  • Quality Analyst
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: