Time Conversion into text

[Svmaxcel]

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]

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.