Convert Second to Hours and mins (over 24 hours)
Hi All,
i need to convert second to Hours and mins and can do so using:
and then converting the format of the cell to HH:MM.
Please Login or Register to view this content.
but this only allows you to go up to 24 hours and i need it to upto at least 50 hours?
any idea's are greatly appreciated
cheers
Last edited by Macdave_19; 04-21-2009 at 09:23 AM.
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
Format the cell with the custom format [h]:mm
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
try
=(Seconds/3600)/24
and format the cell as 37:30:55.
In the format dialog box, select Time and select the above format.
modytrane
Cheers Guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks