Hi Guys,
Was wondering if the was a function or formula which did this.
If cell A1 is this number 811 then A2 will be 8
If cell A1 is this number 812 then A2 will be 9
If cell A1 is this number 813 then A2 will be 10.5
If cell A1 is this number 814 then A2 will be 10.25
Cell A1 would be a rota number (814) and cell A2 would be hours (10.25). Need to be 10.25 hrs not 10 hrs 15 minutes.
So if I typed 814 in cell A1 then the result for A2 would be 10.25
Hope that's clear
Bookmarks