I have just used this =(IF(a1="","",IF(a1<10,a1+12,a1))), which works except any time ending in zero show as 3 digits ie 10:30 shows as 10:3
Thanks
I have just used this =(IF(a1="","",IF(a1<10,a1+12,a1))), which works except any time ending in zero show as 3 digits ie 10:30 shows as 10:3
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks