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.
RajHelaiya's avatar
RajHelaiya
Qrew Captain
8 years ago
Do you mean the start date and end date should be same day? My use case is something like this:

Start date can be 1st dec and end date can be 5th dec. Also I need to know the time of start day and end day so I can display a result. For example: "Outage Duratio" was 4 days and 7 hours. Can this be achieved?