You can also have scenarios where you want to find the number of hours worked. It is the amount of time that you want to find out. In that case, you can use the following formula where time1 and time2 are the times selected from timepickers. We are using the TIMESTR function here to convert the string TIME to a readable format specified here as “HH:mm”.

## Syntax

TIMESTR(time, format)

## Formula

TIMESTR( time2 - time1 , “HH:mm”)

Then the output for values as follows

if **Time1** = 06:16 A.M and **Time2** = 06:16 P.M

Would be 12:00 hours