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

Question

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 hours.

quickbasecoachd · Answer

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".

_anomdiebolt_ · Answer

ToDays([tod2] - [tod1]) will return a number as fraction of a day.&nbsp;ToHours([tod2] - [tod1]) will return the number of integer hours and a decimal representing the fraction of hours.

quickbasecoachd · Answer

... 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.

_anomdiebolt_ · Answer

I was confused because I answered a question without using JavaScript. Its gonna be a bad day - we have 7 inches of snow coming ...

rajhelaiya · Answer

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?

Forum Discussion

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

Related Content

Duration Fields with Pipelines

Snapshot Fields

Create a formula duration over 5 years

Find and Replace Field Values

Proxy fields