Time Format with Colon

[mandilicious]

Hi All

Please assist i need to format below time to have the colon ( : ) be like  03:00:35 and 00:07:51 or what can use to have those colon(:) between.

Thanks

[Anonymous · Accepted solution]

Hi,

By using Time or Time# and give the format what ever you want.

like-TIME(field,'HH:MM:SS')

Thanks

Paridhi

[mandilicious]

Hi Paridhi

Thank you very much for your respond:

Quick one to get AVG Waiting Time i used this expression =AVG(waiting_time)

how will i add my formula to the one you gave me now?

Thanks

[Anonymous]

Like this?? TIME(AVG(waiting_time),'HH:MM:SS')

[mandilicious]

Thanks Shiva it worked