convert numbers to time
Hi all,
I have a spreadsheet with five columns and about 27000 records. Three columns consist of numbers. I want to convert these numbers which represent call time seconds into hours. example 61 should = 1:00:1?
The cells are formatted as general. When I try to change the to custom h:mm:ss; it turns everything 0:00:00! Is there any easier way to change all 27000 records at one time?
Please help!
thanks
It sounds as though the values are Integers - a simple fix - type 86400 into a blank cell, copy it, highlight your Second values (all of them) and run Edit -> Paste Special: Operation: Divide
With those same cells still highlighted now apply a Custom Format of: [mm]:ss
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks Worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks