Percent of time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 11 Aug 2007 03:36 GMT

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!

Reply to this Message

Max - 11 Aug 2007 04:22 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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!

Reply to this Message