Formulas and Functions
Modifying this control will update this page automatically

DUR2HOURS

The DUR2HOURS function converts a duration value to a number of hours.

DUR2HOURS(duration)

duration: The length of time (duration value) to be converted.

Examples

=DUR2HOURS("2w3d2h10m0s5ms") returns 410.1666681.

=DUR2HOURS("10:0:13:00:05.500") returns 1,693.001528.

See alsoDUR2DAYSDUR2MILLISECONDSDUR2MINUTESDUR2SECONDSDUR2WEEKS
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.