I have attached a file with an example.
I just need to transform an accumulated time format into a decimal.
The output is from a program at work.
I have previously used a formula that does not work on this example. I think because this is accumulated hours for a period and not a HH:MM question.
Basically, I need to have a formula to convert 25:30 into 25,5 (IOW 25 hours and 30 minutes).
Try multiplying by 24.
Try this:
=--(LEFT(E4,FIND(":",E4)-1)+MINUTE(E4)/60)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Marked as solved - do you no longer need help with this? Which solution did you choose? Some feedback would be nice.
Happy to help. Thanks for the rep!
Glad you were thanked. I just got ignored ...
Sorry if you felt ignored.
Multiplying for 24 was the solution I went with. I needed to submit the assignment to my boss ASAP, so took the ball and kept running with it.
That's fine, but it isn't the first time you have left help offered by me completely unacknowledged. Please remember that all the help you get here is for free: it's just common courtesy to thank those who've tried to help, even if their solution was not the one you used.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks