Forum Discussion
Excel rounding time to the next increment of 6 seconds
rounding to the next 6 second increment to calculate billing for a call, leave if multiple of 6 already. time is displayed in minutes and seconds 00:00. Need to round up to the next 6 second increme...
Thank you, I was finally able to make the ceiling formula work. Can you advise how i would then multiply the hours:minutes:seconds times a rate to get the billable dollar figure ( 123 hours 15 minutes 25 seconds at a billing rate of 0.008. I can't get it to convert to a dollar figure, only hours and minutes.
Is that 0.008 per hour? If so, use
=time*24*0.008
and format the cell with the formula as number or as currency.
- It’s per minute at 0.008
- Thank you very much for the patience and all of the assistance. I now have my all my spreadsheets completed in 10% of the time it would have taken to do them line by line calculations.