How to deduct two timestamps and get the duration in hours

[Mayura]

Hi

I have a problem where I need to deduct two time stamps and get the result in hours?

Can you help me on this problem?

Best Regards

Mayura

[peterson]

I guess you could only subtract the time in a virtual column, example: [Final time] - [Initial time]
You should use it as a duration type column.

[Suvrutt_Gurjar]

Assuming by duration in hours you mean decimal representation in hours ( so a duration of 2 hr 30 minutes reflects as 2.5 ), please try the function of TOTALHOURS(0 in the following format

TOTALHOURS([TimeStamp 1] -[Timestamp2])

TOTALHOURS() - AppSheet Help

[Mayura · Accepted solution]

Hi Peterson

Thanks for the reply.

I was able to find a solution with your input and working around time expression

Both Hour and Minute expressions works for my problem