Calculate time (hours, minutes, seconds) between two dates

I have tried a couple different formulas however I can't get the output\result to be hh:mm:ss (example: 00:45:06)

This is the most currently formula I tried. DateTimeDiff([LogoutTime],[LoginTime],'%H:%M:%S'). I get an error that this will return a number and I have it set to Time. I changed the data type to string however then I get no results, even through the error is gone (just null in the field).

This is my excel from excel, the Different column is what I would like to see.

Logout Time = 4/19/21 9:40

Difference = 00:45:06

Date Time

Accepted answers

Emil_Kos

Hi,

False alarm 😀

I actually got it:

@apathetichell I missed your response... I am too tired I should get some sleep 🙂

Diff Timev2.yxmd

All comments

apathetichell

O.k. - datetimediff returns only one thing so it has to be seconds/minutes/hours etc... you can parse that as it is into a number or you can keep it as a time and then do a datetimeformat([whatever value you got above],"%H:%M:%S") to get it into a H:M:S: format.