Hi all - total newbie here so you will have to use laymen's terms for me!
I have a spreadsheet that shows employees working times (in HH:MM), breaks, allocated work times and percentages of the difference between time worked and time due. I am trying to sort the data by department - easy done. I'm then trying to sort by variance which is a formulated column of =AN3-AM3 and the cells are formatted as custom hh:mm. Some of these cells show a negative figure and I need to sort it by lowest to highest. Keeps throwing up errors and won't let me do it OR it does it but not in order. Just chucks them anywhere.
I hope I've explained it well enough, please let me know if you need any more info.
Thank You
Bookmarks