Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
8 years ago

Find duration between 2 fields with data type (Time of day) ?

How to find duration when start date field is of type (Time of day) and end date field is of type (time of day). I need to find the total duration between start date and end date in terms of days and ...
App builders
Ask about Quickbase functionality
Errors
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
... assuming that all data entry is done on the same day and does not cross midnight.

I was confused because Raj said "in terms of days and hours.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Yes no problem, but let me know what you are fields are which are capturing the start date and end date.  i suggest that you make fields for those and btw, a user tip is that if you type a T into a date field it will populate to today.

So you may want to default the start date to the current day and then users will type a T to set the date when the ticket is closed, as well as the time.  or else you can have a form rule to check a checkbox that will set the  end date to today and the end time to now.