Trying to convert duration to number
Hey All, Newbie here... I'm building an app for a non-profit that bills in Units. 1 Unit = 15 minutes I have figured out how to calculate in minutes/hours as a duration based on Start Time/...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo problem
ToMinutes(ToTimeOfDay([End Time])-ToTimeOfDay([Start Time]))
That will provide a response as a numeric value for the # of minutes.
If you have control over the data entry, it would be better to have the data entry fields be a time of day field type. If they were that field type, then the formula would be.
ToMinutes([End Time] - [Start Time])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ToMinutes(ToTimeOfDay([End Time])-ToTimeOfDay([Start Time]))
That will provide a response as a numeric value for the # of minutes.
If you have control over the data entry, it would be better to have the data entry fields be a time of day field type. If they were that field type, then the formula would be.
ToMinutes([End Time] - [Start Time])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks Mark! That worked.
------------------------------
Mary Perkins
M3TR1CS Business Solutions
mary.perkins@m3tr1cs.com
------------------------------
