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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.