Hi guys, so I've got quite a big data set of timed results that I need to convert from being in "hh:mm:ss" format to a decimal format so that it is amenable to stats.
I've attached an example. In it I've manually entered in the hours, minutes and seconds and then inserted a simple calculation. The problem is that on a large scale this will be too time consuming.
Any ideas/help?
Cheers
Shane
Hi,
Can you not custom format the cell as [MM]:SS?
For calculation purposes you can directly use them if you convert the formatting to "General" or "Number" formats as they will be in decimals anyway.
=A2*1440 and use general format
Hi
Use cbattrody on #2 [mm]:ss
instead B1 Hours C1 Minutes and D1 Seconds can lead you mistake if you doing manual?
Formula for this?
B2 =TEXT(MOD(A2,1),"hh ""hours, ""mm ""minutes, ""ss ""seconds. """) copy down
Regard
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks