Real time plus preform at task time

**stonefox** · 07-01-2011, 05:03 PM

I have 4 times in cells D38: D4, which tells how long it takes to perform a task - (see attached file), you can put the highest point along with realtime

example:
The time is now 22:57:00 + the largest of the 4 times of 2:50:30 (hours - minutes - seconds) = 01:46:30

another example:

The time is now 13:41:00 + the largest of the 4 times of 2:50:30 (hours - minutes - seconds) = 16:31:30

**ron2k_1** · 07-01-2011, 05:39 PM

What is it that you want sir? And where do you want it?

Would mind actually giving us a real worksheet and show us exactly what you want and where. Pictures don't really help much those trying to provide help.

**stonefox** · 07-01-2011, 06:45 PM

In cells D16 to D19 are calculated some hours: minutes: seconds, which will go before the job is done.

The ages of the furthest (in the example, cell D19 - 7:14:51), I have put together with what the real clock is right now, so I know what time it is when the job is finally solved. Information should appear in cell F20

travian beregning af enheder - engelsk forum 2.xls

**ron2k_1** · 07-01-2011, 07:02 PM

I'm still having a bit of trouble to understand what is that that you really need.

Would this on F20 work?

Please Login or Register  to view this content.

**stonefox** · 07-01-2011, 09:17 PM

If I copy your formel "=MOD(NOW(),1)+MAX(D16:D19)", and insert it in celle F20, I get this error:

"The formula you typed contains an error"

Maybe you can insert the formula in F20 and attach the file ?

-----------------------------------------------------------------------------------------------

A little more explanation

First, which of the cells D16 to D19 with the highest number of hours, minutes, seconds, ( D16)

Then, those hours, minutes, seconds are added to what the time is now 03:05 AM + D16 = 05:53:35 AM (cell F20)

Instead of using AM and PM, 12 hours, I like it better with 24 hours a day. Example clock will not be displayed as 01:00:00 PM, but 13:00:00

**ron2k_1** · 07-01-2011, 10:11 PM

This works for me. But I don't even know whether this what you need:

Please Login or Register  to view this content.

If it doesn't work, maybe your version of excel does not support the formulas above, due to because language differences - the formulas are probably written differently with your version.

Try it, see if it works on your excel, and then let us know whether this is what you need.

**stonefox** · 07-02-2011, 05:35 AM

I have trouble with the language differences, but I have translate the formal command to danish, but still get en error messages.

have you tried your formula in your English version of Excel and seen whether it works or you may on closer inspection see an error in your own code?

My danish translate looks like:

English
=IF((MOD(NOW(),1)+MAX(D16:D19))>TIME(23,59,59),((MOD(NOW(),1)+MAX(D16:D19))-TIME(23,59,59)+TIME(0,0,1)),MOD(NOW(),1)+MAX(D16:D19))

danish
=HVIS((REST(NU(),1)+MAKS(D16:D19))>TID(23,59,59),((REST(NU(),1)+MAKS(D16:D19))-TID(23,59,59)+TID(0,0,1)),REST(NU(),1)+MAKS(D16:D19))

**DonkeyOte** · 07-02-2011, 05:42 AM

Perhaps:

Please Login or Register  to view this content.

above assumes a ; delimiter - modify as required.

The above assumes you only want a Time return - so 20:00 + 10:00 should return 06:00 [ie 0.25 rather than 1.25]

If you prefer to use H16 to the MAKS function replace as appropriate.