PDA

View Full Version : Time Conversion into text



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.

p45cal
10-24-2017, 07:09 AM
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.If your time is in cell A1:
=TEXT(FLOOR(A1,1/24),"hh:mm") & " - " & TEXT(CEILING(A1,1/24),"hh:mm") & " hrs"



How can I convert time
Example 00:12:16 to seconds.If that time is in Excel Date/Time, multiply by 86400.