Percent of time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I would like to know how to get percent of time? i.e. 30% of 12:00 or 70
of 11:00 and still able to sum up / add-up the total results automatically?

Thanks!
 
If the source times are real times, just multiply it, and format the formula
cell as custom: [h]:mm to enable rollover of results exceeding 24 hours.

Eg if you have in A1: 12:00, you could have in B1: =870%*A1, with B1
formatted as custom: [h]:mm. B1 will return: 104:24
 
Back
Top