Formula help
Hello, I have a formula - numeric field I am using to convert a duration field into a numeric field so I can create a total field. How would I change my formula to treat blank as 0? The origina...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this. I'm using the Nz function to convert any null to a zero
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=112&rl=dv
If(
ToDate([End Date/Time1]) > ToDate([Start Date/Time1]),
// This part calculates anything pass midnight
(ToTimestamp(ToDate([End Date/Time1]),[End Time1]) - ToTimestamp(ToDate([End Date/Time1]),ToTimeOfDay("12:00 am")))
// This part calculates everything before midnight
+ (ToTimestamp(ToDate([End Date/Time1]),ToTimeOfDay("11:59 pm")) - ToTimestamp(ToDate([End Date/Time1]),[Start Time1])) + Minutes(1),
Nz([End Time1]-[Start Time1])
)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=112&rl=dv
If(
ToDate([End Date/Time1]) > ToDate([Start Date/Time1]),
// This part calculates anything pass midnight
(ToTimestamp(ToDate([End Date/Time1]),[End Time1]) - ToTimestamp(ToDate([End Date/Time1]),ToTimeOfDay("12:00 am")))
// This part calculates everything before midnight
+ (ToTimestamp(ToDate([End Date/Time1]),ToTimeOfDay("11:59 pm")) - ToTimestamp(ToDate([End Date/Time1]),[Start Time1])) + Minutes(1),
Nz([End Time1]-[Start Time1])
)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------