Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

Convert a second value into hours mintues and seconds

What i need to achive :

There is a value that is stored in the database ( call_req.time_spent_sum) this has a value in seconds


I need this value to be given as hours:mintues:seconds
so if call_req.time_spent_sum = 4830
i need to get 1:20:30
this is got by
3600 + 1200 +30

now after getting this value

i also have to get the sum of the amount of hr:min:sec spent on solving a particular problem in that day .

there are a few functions i have come across

such as
hour
minutes
second
CTime
Time

Ive tried these but I am unsuccessful in getting the solution.

Please advice
ASAP .
0
picasothakkar
Asked:
picasothakkar
  • 2
1 Solution
 
bdreed35Commented:
Try this formula:

local numbervar total_secs := {call_req.time_spent_sum};
local numbervar hrs := int(total_secs / 3600);
local numbervar mins := int(remainder(total_secs,3600)/60);
local numbervar secs := remainder(remainder(total_secs,3600),60);

totext(hrs,0,"") & ":" & totext(mins,0,"") & ":" & totext(secs,0,"")
0
 
wykabryanCommented:
I would suggest that in the CR you summarize your seconds before you display them with the above formula.  This way you are able to acheive both results in multiple areas.  
0
 
Ken TurnerCommented:
If you need to convert seconds to a proper time field (as opposed to a string field as described above), all you need is:

time({YourSeconds}/24/60/60)
0
 
bdreed35Commented:
Ken:

I agree that will work, just with the caveat that when the number of seconds are >= 86400, then you will not see the elapsed correct time.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now