Excel help needed

[shadytree]

HELP PLEASE !! any Excel spreadsheet guru's on here ?


I'm trying to add a time difference calculation into a sheet.

for example:

The Value at 9.00am is 0
The Value at 4.00pm is 1,000,000

So splitting the value of one million between 7 hours.

As the clock ticks on I want the value (live) on the sheet to tick up as well ? does that make sense ?

Any ideas how to formulate this on excel



>>> Edited by shadytree on Tuesday 11th January 12:45

[Plotloss]

It can be done I imagine, via vbScript.

Its not going to be easy though, dealing with a timestamp seldom is...

[fish]

Give me a minute.....

[fish]

Done it I just need your e-mail address.

YHM

James

[.Mark]

At 12:54

fish said:

Give me a minute.....

Then at 13:08

fish said:

Done it I just need your e-mail address. YHM James

Slack. Very slack

[tonyhetherington]

can you tell us the answer?! I like to do what I can in Excel so to see different things like this is always educational!