Hello all, I'm a newbie so bear with me. I have data that I pull that is in a HH:MM format. Example [375:55] which is 375 hrs and 55 mins. I need to convert it to a single number like (375:55 converted to 22555mins) so I can calcuate percentage of time lost.
example: total time [290:19] lost time [18:14] ='s [6.28%] of lost time
Thanks for any help
Hi
If your time is real time , not text looking like time, your percentage is given by lost_time/total_time
No need to change to decimal or anything
EDIT see attached Lost Time.xlsx
Hi,
Why do you need to convert to a number?
With 290:19 in A1 and 18:14 in B1, then =B1/A1 results in 6.28
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
k, how would I change it from text to a usable number? When I try to do that excel thinks the hrs are mins and the mins are secs.
try multiplying it by 60, that should change mins to hours, and seconds to mins
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Even formatted as text the simple division suggested by Richard and Pepe should work OK, did you try those suggestions? What results did you get?
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks