time calculations

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi,

I'm struggling with a time calculation problem. Here's
the code I'm using:

=Format((([MonIN]-[MonOut])-(TimeValue("00:30"))),"Short
Time")

If I put TimeValue() in front of the MonIN/MonOut I get
an error when MonIN/MonOut is blank. Without the
TimeValue() I'm getting inconsistent results. Sometimes
correct, sometimes not.

Any ideas?

Thanks in advance.
 
Try with IIf and the TimeValue()
something like (in the air..)

IIf(IsNull(MonIn-MonOut), 0, MonIn - MonOut)
 
Thanks I'll give that a try.
-----Original Message-----
Try with IIf and the TimeValue()
something like (in the air..)

IIf(IsNull(MonIn-MonOut), 0, MonIn - MonOut)
-----Original Message-----
Hi,

I'm struggling with a time calculation problem. Here's
the code I'm using:

=Format((([MonIN]-[MonOut])-(TimeValue ("00:30"))),"Short
Time")

If I put TimeValue() in front of the MonIN/MonOut I get
an error when MonIN/MonOut is blank. Without the
TimeValue() I'm getting inconsistent results. Sometimes
correct, sometimes not.

Any ideas?

Thanks in advance.
.
Click to expand...
.
Click to expand...
 

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

Run time error 2
Application.Wait 2
Find time difference and display it in hours 1
Issue with numbers and Time 10
When a time goes into the next day, negative hour error 2
Discrepancy with time calculations 3
Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Look up between 2 times over midnight - is there an easier way than recordset code? 20

Back
Top