Excel Formula to convert time into hours billed

August 25, 2012 at 08:44:18
Specs: Windows Vista
Need Excel formula to convert time into hours billed. For instance if I enter a time between 3:00-3:15, it will convert it to .25. If I enter a time between 3:16-3:30, it will convert it to .50; 3:31-3:45=.75, etc...

See More: Excel Formula to convert time into hours billed

Report •


#1
August 25, 2012 at 12:37:19
If I enter a time between 3:16-3:30, it will convert it to .50; 3:31-3:45=.75, etc...

Your going to bill me for .50 when you only worked for 14 minutes???
But if you work for 15 minutes, from 3:00 to 3:15 your only going to bill me for .25??

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question