if 1.68 is hours then divide by 24 to get Excel time and add the two format as excel time





--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SallyGirl" wrote in message ...
The 1.68 is the value from another formula of time worked.

"SallyGirl" wrote:

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