General information
Category:
Coding, syntax & commands
Sorry this is kinda off the top of my head.
Might want to start with totaling the SEC(CTOT(field)) the MINUTE(CTOT(field)) and the HOUR(CTOT(field)) values. Then dividing by 60 to get the final answer?
Aloha,
James
>Hi all
>
>I have a field that store's time like this
>00:00:45 forty five seconds
>00:52:50 fifty two minutes and fifty seconds
>01:20:50 one hour and twenty minutes and fifty seconds
>
>And I want to do a sum on it to see how many hours was spend one something how I do it ?
>
>Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only