Basis on start time and end time, require output in HH:MM:SS

[VBABEGINER]

Hi All,
Need your help..

I have Start Time

12/1/2017  2:32:15 PM

I have End Time

12/1/2017  6:24:38 PM

and basis on this I made output this..

[TABLE="width: 154"]
<tbody>[TR]
[TD="class: xl63, width: 154"]232.38[/TD]
[/TR]
</tbody>[/TABLE]

formula for this..

=IF($A174<>"",(B174-A174)*24*60,"")
B = end time
A = start time

Now, requirement is, instead of this..

[TABLE="width: 154"]
<tbody>[TR]
[TD="class: xl63, width: 154"]232.38[/TD]
[/TR]
</tbody>[/TABLE]

I want output in this format..(HH:MM:SS)

How do i get the same please..

 

[arthurbr]

Just remove the *24*60 part and try to understand why
Format as needed

 

[VBABEGINER]

Ok, I have tried this..

=TEXT((B174-A174),"HH:MM:SS")

Thanks for reply, Sir..

Just remove the *24*60 part and try to understand why
Format as needed

 

[arthurbr]

You're welcome

Be aware that if the time difference is larger then 24hr you need to use the [h]:mm format