Skip to main content
Question

Adding Duration Fields

  • March 6, 2020
  • 0 replies
  • 63 views

I am trying to add duration fields but if one is blank the total doesn't show.  Any suggestions?

[End Time 1] - [Start Time 1]  =  [Time 1 Total]
[End Time 2] - [Start Time 2]  =  [Time 2 Total]
[End Time 3] - [Start Time 3]  =  [Time 3 Total]

So if [Time 1 Total] is 1 hour and [Time 2 Total] is 30 min and [Time 3 Total] is blank it won't give me a [Total Time] ([Time 1 Total]+[Time 2 Total]+[Time 3 Total])

How do I get a total if one of the [Time Total Fields] is blank (null)

------------------------------
Mark Comish
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,
use the Nz() function which will treat any nulls as zeros.

The formula for the field [Time 1 Total]  should be

Nz([End Time 1] - [Start Time 1])

etc for each of the three fields.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------