Svmaxcel
10-24-2017, 06:46 AM
Hi all,
I want to convert time into text.
For example if cell has a time 00:15:13 then it should be 00:00 - 01:00 hrs.
If its 15:33:47 then it should be 15:00 - 16:00 hrs.
How can we formulate it, please help.
One more question.
How can I convert time
Example 00:12:16 to seconds.
I want to convert time into text.
For example if cell has a time 00:15:13 then it should be 00:00 - 01:00 hrs.
If its 15:33:47 then it should be 15:00 - 16:00 hrs.
How can we formulate it, please help.
One more question.
How can I convert time
Example 00:12:16 to seconds.