software

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

Hi Sally,

1.68 is NOT 1 hour 68 minutes it is 1 day 16 hours 19 minutes
you must use a colon not a period. Time is measure as fraction of a day.
www.mvps.org/dmcritchie/excel/datetime.htm

use the correct Excel syntax and you will have a working formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;SallyGirlquot; gt; wrote in message ...
gt; I am trying to create a formula where it automatically calucates an estimated
gt; completion time. Where my cell adds the 1.68 to the 5:30 to product the time
gt; 7:38. Since time is in minutes and the 1.68 would = 1 hour 68 minutes.
gt;
gt; Time 5:30am
gt; Hours worked 1.68
gt;
gt; Estimated completion time
gt;
gt; Any Suggestion??? Thanks in advance
The 1.68 is the value from another formula of time worked.

quot;SallyGirlquot; wrote:

gt; I am trying to create a formula where it automatically calucates an estimated
gt; completion time. Where my cell adds the 1.68 to the 5:30 to product the time
gt; 7:38. Since time is in minutes and the 1.68 would = 1 hour 68 minutes.
gt;
gt; Time 5:30am
gt; Hours worked 1.68
gt;
gt; Estimated completion time
gt;
gt; Any Suggestion??? Thanks in advance

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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;SallyGirlquot; gt; wrote in message ...
gt; The 1.68 is the value from another formula of time worked.
gt;
gt; quot;SallyGirlquot; wrote:
gt;
gt; gt; I am trying to create a formula where it automatically calucates an estimated
gt; gt; completion time. Where my cell adds the 1.68 to the 5:30 to product the time
gt; gt; 7:38. Since time is in minutes and the 1.68 would = 1 hour 68 minutes.
gt; gt;
gt; gt; Time 5:30am
gt; gt; Hours worked 1.68
gt; gt;
gt; gt; Estimated completion time
gt; gt;
gt; gt; Any Suggestion??? Thanks in advance

SallyGirl,

Try =TIME(5,30,00)

regards
Runner77--
Runner77
------------------------------------------------------------------------
Runner77's Profile: www.excelforum.com/member.php...oamp;userid=30388
View this thread: www.excelforum.com/showthread...hreadid=507103