Home » Forums » Open Source Learning Center » Question and Answer

time as a fraction of hours

Submitted by misdemina on 15 February, 2014 - 05:07

Is there an easy way to convert H:mm to a fraction of Hours
I would like to subtract a finish time from a start time and have the result as a fraction of hours.
example:
Start 15:30 finish 18:45 total 3.25 hrs duration

‹ Need help with a loop copying data from a worksheet to a text file newbie question: identifying returning queries in a speadsheet ›
»
Nick's picture

a1 15:30 a2 18:45 a3

Submitted by Nick on 15 February, 2014 - 07:56.

a1 15:30
a2 18:45
a3 =(a3-a1)*24

format a3 as 0.00 and you will have:
3.25

»