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.
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.
04:30 to 430
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