How to Put Future time in a calc

[Salesman0Gil]

Quick question....

I am trying to make a time subtraction.

Sept 26, 2004 Midnight - Current Time of the Current Day.

So the answer would be both x many days left (which I have all ready got), and Y many hours, z many min, s many secs ( I can't get this one)

Any ideas?

Salesman

[Fitch]

Time (24, 0, 0) - Status (CurrentTime)

Is that what you're looking for?

[Salesman0Gil]

Not exactly, but it put me on the right track. I wanted:

Time( 24+(num of days between * 24), 0, 0)-(Status( CurrentTime))

where number of days between= (September 26,2004 - Today)

So I get a read out of 1328:24:21 until my wifes due date....

It kind of takes the old cliche "Whose Counting Anyway", to whole new extreme...