Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a data file that contains Date and Product. Example:
Date Product
1/2/2016 00:12 AM ProductA
3/12/2016 8:12 AM ProductB
...
6/27/2016 5:54 PM ProductZ
i want to get the peek hours of a product regardless of the date. I just need the time. For example, product A is sold mostly at 5:00 PM.
I used the expression Time(date(Date)) but it returns all instances of time in each date. I just want all common instances of time to appear once. Thank you!
Hi,
Try this.
Time(Date(Date) - Floor(Date(Date)))
Regards,
Kaushik Solanki
Hi,
Try this.
Time(Date(Date) - Floor(Date(Date)))
Regards,
Kaushik Solanki
hi,
Try
=Hour(Date)
-TR,
Abdul
Really worked for this situation. Thanks!