View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zyberdoc zyberdoc is offline
external usenet poster
 
Posts: 3
Default How to calculate time in 1/100 decimal while it is entered 1/60

Entering time in excel to create a time sheet 7.00am start 14.30 finish
would give a figure of 7.30 hrs as worked , actually 7.5 hrs is the hours
worked. How does one achieve this answer