Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Ramakrishna Reddy

Former Member
Former Member replied

That is the formula?

Unless you refer to the seconds formula

Just use datediff()

@seconds

DateDiff ("s", startDateTime, endDateTime)

replace start and end datetimes with your fields.

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question