View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrAcquire MrAcquire is offline
external usenet poster
 
Posts: 62
Default calculating decimals

For a comprehensive discussion about using Excel for timesheets, see
http://www.cpearson.com/excel/overtime.htm

"Headacheaday" wrote:

On our timesheets we must enter quarter hours as .15, .30, .45. Is there a
way to
enter these decimals but have excel calculate them as .25, .50, .75.
Thanks,