Formula for converting to Hours,Mins and Secs
I have a field that is formatted as a time field which gives me the time in seconds only. I just need to know how to convert the seconds into hh:mm:ss format,how do I write a formula for converting the time kindly help me.
Thanks in advance
That is the formula?
Unless you refer to the seconds formula
Just use datediff()
DateDiff ("s", startDateTime, endDateTime)
replace start and end datetimes with your fields.