If the time in one cell is 07:52 how do i make a second cell populate with 07:00-08:00? i would like to enter any time into a cell and then have another cell correspond with the relevant hour time period, so for example if i entered 03:42, then the corresponding cell would populate with 03:00-04:00. thanks in advance
try this formula, assuming the original time is in A1
=TEXT(TIME(HOUR(A1),0,0),"HH:MM")&"-"&TEXT(TIME(HOUR(A1)+1,0,0),"HH:MM")
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Try this
Formula:
Please Login or Register to view this content.
Hi & welcome to the board.
How about
=TEXT(HOUR(E3)/24,"hh:mm-")&TEXT((HOUR(E3)+1)/24,"hh:mm")
HOLY SMOKE ! that was rapid, and it works a treat!!!
thank you so much Dosydos !!!! appreciated
thanks again for the swift reply, fantastic!
=text(time(hour(a1),0,0),"hh:mm")&" - "&text(time(hour(a1)+1,0,0),"hh:mm")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks