I am able to change a cell containing seconds to show as either minutes or hours, but I haven't been able to find a good way to change those seconds to hours:min:seconds. Is there a way to do that?
For example, my cell shows a login time of 29692 (I know that that is calculated as seconds). Right now, I use convert(A1,"sec","hr") and then I can see that it is 8.247 hours. What I would like to show is 8:14:52 if that is possible.
Try:
=A1/86400
formatted as time h:mm:ss
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You are a lifesaver!
When I then make that into a bar graph, will it show as just the seconds since the cell is just formatted to show the way I'd like and not the actual value? Is there any way to get a graph to show it in my format?
It should show up with same format as you have in that time formatted column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks