perform calculations using time arguments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calc the time difference in hh:mm for shift work? 10
Another rounding issue 2
23:00 <> 23:00 16
Working with time calculations 3
Spurious Formula Omits Adjacent Cells 2
Spurious Formula Omits Adjacent Cells 1
Vlookup and return sheet name also 2
Calculate elapsed time excluding specific timeframe 10

Back
Top