ExcelBanter - Percent of time

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Percent of time (https://www.excelbanter.com/new-users-excel/153844-percent-time.html)

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jay" wrote:
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!