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.
It was Really great info. You are genius