Hi, basically I have a a table of date representing durations and I can't figure out how to convert this into a decimal number. For example 260:30 would output 260.5?
Multiply by 24 would be an answer but when I look closer I see that the orginal data is not represented as time data but as a number! So 260 hours 30 minutes is represented 260.30
What I would like to see is something that calculates so 260.30 = 260.5, 12.45 = 12.75, etc.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.