Ask Your Question

Hours interval

asked 2017-02-28 21:28:38 +0200

nickd006 gravatar image

Looking for a formula that will calculate the number of hours when the start time and end time span more than 24 hours

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-01 05:34:23 +0200

You may use TEXT(<ref>, "[HH]") to get the string with requested value. If you need a number, you may multiply your datetime value by 24, and have a float with whole part as number of hours, and fractional part as fraction of an hour (rationale: datetime is a floating-point value that represents time as number of days). Formatting the result as Number (opposed to Time) will give you result in convenient form.

edit flag offensive delete link more


Thanks. I will try that

nickd006 gravatar imagenickd006 ( 2017-03-03 13:28:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-28 21:28:38 +0200

Seen: 176 times

Last updated: Mar 01 '17