Time formula

[SallyGirl]

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

[David McRitchie]

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

"SallyGirl" <[email protected]> wrote in message news:[email protected]...
> 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

[SallyGirl]

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

[David McRitchie]

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" <[email protected]> wrote in message news:[email protected]...
> 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

[Runner77]

SallyGirl,

Try =TIME(5,30,00)

regards
Runner77