Thread: Time formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SallyGirl
 
Posts: n/a
Default Time formula

I am trying to create a formula where it automatically calucates an estimated
completion time. Where my cell adds the 1.68 to the 5:30 to product the time
7:38. Since time is in minutes and the 1.68 would = 1 hour 68 minutes.

Time 5:30am
Hours worked 1.68

Estimated completion time

Any Suggestion??? Thanks in advance