ExcelBanter - perform calculations using time arguments

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - perform calculations using time arguments (https://www.excelbanter.com/excel-worksheet-functions/85119-perform-calculations-using-time-arguments.html)

Derek

perform calculations using time arguments

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

perform calculations using time arguments

Hi Derek

Try F1-TIME(8,0,0)

--
Regards

Roger Govier

"Derek" wrote in message
...
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

perform calculations using time arguments

--
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?

All times are GMT +1. The time now is 05:30 AM.