software

How to perform calculations using time as arguments?

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

what up?

Hi Derek

Try F1-TIME(8,0,0)

--
Regards

Roger Govierquot;Derekquot; gt; wrote in message
...
gt; How to perform calculations using time as arguments?
gt;
gt; E.g. quot;F1-F2quot; works fine where both cells contain values with (h:mm)
gt; format,
gt; but quot;F1-8:00quot; returns an error. Also, when using =IF(), when
gt; [value_if_true]
gt; is quot;f1-8:00quot; I get a formula error.
gt;
gt; what up?

--
Dale H.
quot;Derekquot; wrote:

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