-
Multiply time with currency? Show the correct format. - Google Product Forums
September 15, 2018 at 12:31:09 AM UTC - permalink -Try: A5: =(A3 24) A4
Note time is stored in Google Docs spreadsheets as a fraction between 0 and 1, e.g. 12:00:00 equals 0.5. By multiplying this fraction by 24 you get the time in hours (with minutes and seconds as a decimal fraction of the hour)
-
- https://productforums.google.com/forum/#!topic/docs/782w4ZzEVR0