Time difference between two date/time fields

[OlivierS]

Hi,

I've been trying to figure out the differences between two date / time fields.

I've tried a couple of options and I thought I nailed it by doing a =TEXT(D2-C2,"d h:mm:s")

[TABLE="width: 633"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Conversation ID[/TD]
[TD]Date Post Published[/TD]
[TD]Date Post Received[/TD]
[/TR]
[TR]
[TD]7 5:03:52[/TD]
[TD="align: right"]3246953[/TD]
[TD="align: right"]8/20/15 15:44[/TD]
[TD="align: right"]8/26/15 20:48[/TD]
[/TR]
[TR]
[TD]6 8:40:41
[/TD]
[TD="align: right"]3240038[/TD]
[TD="align: right"]8/20/15 21:48[/TD]
[TD="align: right"]8/26/15 6:29[/TD]
[/TR]
[TR]
[TD]6 19:31:18[/TD]
[TD="align: right"]3240754[/TD]
[TD="align: right"]8/20/15 13:31[/TD]
[TD="align: right"]8/26/15 9:02[/TD]
[/TR]
</tbody>[/TABLE]

But, it looks like MsExcel can't substract days ... it seems to always be 1 day higher than expected ...

So, is there a quick and easy way to do that?

Thanks

 

[cbatrody]

Hi,

You can just do D2-C2 and custom format the cell d:hh:mm:ss, OR just [hh]:mm:ss

 

[OlivierS]

Thanks, works fine