Thread: Minutes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bobby Bobby is offline
external usenet poster
 
Posts: 75
Default Minutes

Hi there,

I have a timesheet which works out working hours e.g. Time in 8:52 time out
12.00 the answer is 3.13 so I then manually calculate the minute bit 0.13*60
which equals 8 minutes. Is there any clever way to calculate this to show
hours and minutes?

TIA
--
Bobby