number.... text..... convert..... HEADACHE!
So, my problem is simple but for the life of me I cannot figure it out.
I have a time in F2 12:35
In G2 I want to display the first two digits of the time 12
I tried =left(f2,2) but thats just for text
I need to sort arrivals by hour and then give average length of stay based on arrival by hour...
Any help would be greatly appreciated!
TLS
Last edited by romperstomper; 06-17-2011 at 09:06 AM.
TaraLeigh,
Give the =HOUR() formula a try:
=HOUR(F2)
Hope that helps,
~tigeravatar
Try = Hour(A1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Re: number.... text..... convert..... HEADACHE!
I KNEW it was something simple like that!!
I cannot thank you enough.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks