I want to convert time 04:00 to 400. I have a lot to manually change on a weekly basis and just want to know if theres an easier way.
I want to convert time 04:00 to 400. I have a lot to manually change on a weekly basis and just want to know if theres an easier way.
Hi,
And what should 04:30 (hh:mm) be? 430 or 450? And should it be a number or text?
Perhaps it would help if you tell us what you want to use the 400 for.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
04:30 to 430
how do you want minutes to show up? should 4:30 be 430, or 450?
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.
If the time is in A2 you can use this formula in B2
=TEXT(A2,"hhmm")+0
....or for display purposes only you could custom format your original cells as hmm
Audere est facere
Thank you so much Daddylonglegs! It worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks