perform calculations using time arguments

[Derek]

How to perform calculations using time as arguments?

E.g. "F1-F2" works fine where both cells contain values with (h:mm) format,
but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true]
is "f1-8:00" I get a formula error.

what up?

[Roger Govier]

Hi Derek

Try F1-TIME(8,0,0)

--
Regards

Roger Govier


"Derek" <[email protected]> wrote in message
news:[email protected]...
> How to perform calculations using time as arguments?
>
> E.g. "F1-F2" works fine where both cells contain values with (h:mm)
> format,
> but "F1-8:00" returns an error. Also, when using =IF(), when
> [value_if_true]
> is "f1-8:00" I get a formula error.
>
> what up?

[Bigbafa]

--
Dale H.



"Derek" wrote:

> How to perform calculations using time as arguments?
>
> E.g. "F1-F2" works fine where both cells contain values with (h:mm) format,
> but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true]
> is "f1-8:00" I get a formula error.
>
> what up?