I’m doing a calculation where I deduct one timestamp from another. I want the result in hours with two decimals, for example 16:00-15:30 would be 0.5 hours. What cell format should I use?
Calc stores all timestamps as a decimal value where 1 equals 24 hours. So you could just do the calculation and display it in a cell without setting the format of the cell and get the decimal hours format by multiplying the cell by 24.
Example:
A B C
2 12:00 13:30 =(B2-A2)*24
You will see 1,5 in cell C2.
I have calculated hours per day, the sum of these hours is 19:30 in HH:MM format, all of which is fine and correct. Multiplying the 19:30 by 24 gives me 12 in “13” format or 12:00 in HH:MM format but 19.50 in number format, 0.00 which solves [finally] my aim to get total $ for total time spent. Hope this helps