I have a column of times in the 24hr format xx:xx.
I would like to convert this to a single value between 0 and 23.
For example, the times 11:45, 11:29, and 11:02 should all be converted to 11.
Likewise, 0:51, 0:39, and 0:00 should be converted to 0.
I think this is fairly simple, but I cannot figure it out for some reason....
Thanks
Last edited by ctrap33; 03-09-2015 at 10:35 AM.
Try this....
and copy down.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
how 'bout this lil guy:
Formula:
Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Wow, I thought it was a simple built-in function. Brain fart on my part. Thanks
You're welcome.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark 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