Search code examples
google-sheetstimeformulaspreadsheet

How to multiply hours past 24h

I have a basic table to keep track and charge for my work. It`s working really well except that when the total hours reach 24h the formula takes "TIMEVALUE" as 0.

formula = TIMEVALUE(F4) * 24 *25

Hoe can I multiply let`s say 26:30 hours y 25$?

Thankas in advance

Timetable

Solution

  • If you have 26:30 hours and 1 hour costs 25$ you can do:

    =VALUE(A1)*24*25

    enter image description here

    VALUE of a duration will give you the number of days. So for example, 24:00:00 will be 1 and 26:04:32.000 will be 1.086481481. So as the formula above demonstrates, you can just multiply this by 24 to get the number of hours even if it goes above 24 hours.

    VALUE