Marking start time /end time

[Ron*/*]

Hi all, ** Newbie alert **

Happy to join your community!

I've got an issue with start and end time columns.

I have one column for call start time and another for call end time.
I'd like to mark the cells across the two columns when a call starts at one hour and ends at another:

e.g:
Call started at 11:55
Call ended at 12:15

Thanks in advance
Ron

[AliGW]

So what's the issue that you wish to resolve?

[Glenn Kennedy]

Maybe by conditonal formatting, using this:

=HOUR($A2)<>HOUR($B2)

[mohan.r1980]

Try
Assuming A2 have Start Time and B2 have End time

Please Login or Register  to view this content.

[Ron*/*]

Thank you Glenn & mohan.

Both methods worked

Ron

[Ron*/*]

Hi Aligw,

The hour gap causes data discrepancies in my report.

Ron

[AliGW]

Thanks for that.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.