Time Calc backwards

[bnwash]

Hi,

I after formula which will allow for the entering of a time then min and sec and values will count the time backwards
This will be used as a time Calculator
I have attached an example

Assistance appreciated

[berlan]

Hi bnwash,

In cell A7, type in:

Please Login or Register  to view this content.

Then copy the cell across to A6 and A5.

Hope that works.

Best,
berlan

[FDibbins]

Are you saying you want this to count down live? Or you just want to fill cells with values?

[bnwash]

No just fill in the Values

[bnwash]

Bertan,

You code works well but I want it to count back from what ever time in A8

Thanks

[FDibbins]

OK well 1st, your "times" are not really time, they are text. You enter time with :

	A	B	C
12	11:54:10	0	30
13	11:54:40	2	30
14	11:57:10	2	50
15	12:00:00

A14=A15-TIME(0,B14,C14)
copied upwards

[bnwash]

Well, you are really confusing me now

[FDibbins]

OK with what? "you are confucing me" doesnt really tell me how to help you

[berlan]

@FDibbins, why didn't I think of the time function... good stuff!

So basically, if you want to convert to time values, use FDibbins approach. Added both into the attached example.

Cheers,
berlan

[bnwash]

Sorry
I have it now
I am very appreciative of the assistance

Just one more thing please
How can I total the minutes in b and the seconds in C
The minutes I can do but the seconds if they are more than a minute need to be added to col b
Can you suggest something ?

[bnwash]

I have added the altered example with a couple of assistance required please

Much appreciated

[berlan]

Try the attached.

Cheers,
berlan

[bnwash]

That's really great thanks so much
No can we just fix the value in A7 so that when it is altered A6 etc. adjust accordingly

Again thanks

[FDibbins]

If you change the value in A7, the rest change automatically

B9=SUM(B4:B8)+INT(SUM(C4:C8)/60)
C9=MOD(SUM(C4:C8),60)

[bnwash]

Thanks for your assistance