calculate percentages of 8 hour day

  • Thread starter Thread starter digitalmuse
  • Start date Start date
D

digitalmuse

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
 
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
 
Thanks - works perfectly.

Roger Govier said:
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
Click to expand...
 

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

Time Calculated minus breaks & lunch 2
Calculation based on 2 seperate ranges 9
Need Help 5
Stuck - VB Help needed 18
Macro adding a range of percentages 1
Changing hour and minutes to percentage of hours 1
Calculating average of percentages 7
HOW TO SPLIT FIGURES BY MACRO 2

Back
Top