Percent of time

J

Jay

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

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding rota 0
Showing 24 hour time along X-axis 0
Averaging by half hour time intervals. 0
Min, Max 3
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
calculate total hours/minutes from two time cells 7
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
problem with time subtraction 7

Top