G
Guest
If you have a list of times eg:
00:00
00:15
00:30
00:45
01:00
etc, how can you sort them so you can only see those ending in 0? Have
tried a range of filters and also an IF statement, but format keeps showing
full hh:mm:ss in formula bar when I do either of these, despite having set up
a custom format for hh:mm, which still shows as cell format in Format Cell
menu. Any help much appreciated
00:00
00:15
00:30
00:45
01:00
etc, how can you sort them so you can only see those ending in 0? Have
tried a range of filters and also an IF statement, but format keeps showing
full hh:mm:ss in formula bar when I do either of these, despite having set up
a custom format for hh:mm, which still shows as cell format in Format Cell
menu. Any help much appreciated