Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate percentages of 8 hour day
I need to create a formula that will display a total amount as a percentage
of an 8 hour day column b is a named range "starttime" and column c is a named range "endtime" the difference or result is what i need to display in column J as a percentage of an 8 hour day |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate percentages of 8 hour day
Hi
Excel stores times as fractions of a day (24 hours). Therefore =(Endtime-Starttime)*24/8 or =(Endtime-Starttime)*3 Format the cell with the formula as Percent If starttime and endtime are likely to cross the midnight barrier, then you would nee to use either =MOD(Endtime-Startime,1)*3 or =(Endtime-Starttime+(End time<=Starttime))*3 -- Regards Roger Govier "digitalmuse" wrote in message ... I need to create a formula that will display a total amount as a percentage of an 8 hour day column b is a named range "starttime" and column c is a named range "endtime" the difference or result is what i need to display in column J as a percentage of an 8 hour day |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculate percentages of 8 hour day
Thanks - works perfectly.
"Roger Govier" wrote: Hi Excel stores times as fractions of a day (24 hours). Therefore =(Endtime-Starttime)*24/8 or =(Endtime-Starttime)*3 Format the cell with the formula as Percent If starttime and endtime are likely to cross the midnight barrier, then you would nee to use either =MOD(Endtime-Startime,1)*3 or =(Endtime-Starttime+(End time<=Starttime))*3 -- Regards Roger Govier "digitalmuse" wrote in message ... I need to create a formula that will display a total amount as a percentage of an 8 hour day column b is a named range "starttime" and column c is a named range "endtime" the difference or result is what i need to display in column J as a percentage of an 8 hour day |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Items Per Hour | Excel Discussion (Misc queries) | |||
Calculate Pounds Per Hour | Excel Discussion (Misc queries) | |||
Trying to calculate percentages | Excel Worksheet Functions | |||
Calculate rate per hour | Excel Discussion (Misc queries) | |||
calculate percentages | Excel Worksheet Functions |