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
There is not enough information to be able to do that calculation, since we do not know the day of the start and the stop.

You need to record the start date and the start time and the end date and the end time.  That can be done either with 4 fields or two fields of type "date/time".