Forum Discussion
Solved
Change time to specific time frame
Hi, I want to add some condition however it is for Time. I am working on a report which has to be shown in hourly basis. Let's take an example : - Below are the timings and i want them to b...
I plugged this formula into your cell E93 and it worked.
=TEXT(HOUR(C93),"00")&":00 TO "&TEXT(HOUR(C93)+1,"00")&":00"
The key to it is the HOUR function. That, along with the need to turn all the numbers into text and format them appropriately, and then concatenate the text strings.
I plugged this formula into your cell E93 and it worked.
=TEXT(HOUR(C93),"00")&":00 TO "&TEXT(HOUR(C93)+1,"00")&":00"
The key to it is the HOUR function. That, along with the need to turn all the numbers into text and format them appropriately, and then concatenate the text strings.