M
martin.g.g
I need to enter a formula in a cell that that has to be multi function
It needs to be able to work out the difference between two time
entered in two cell and show the result in hours and minutes (no
time). It also need to be able to recognise the letter 'H' displayed i
the same cells instead of the time and display the time as '0:00'
Finally it needs to also be able to recognise the letter 'S' displaye
the same '0:00'. I belive this will require 3 fomulas and some kind o
linking Can this be done and can any one point me in the righ
direction to help, Better still forward me and example that I can pla
with.
Hopfully
Marti
It needs to be able to work out the difference between two time
entered in two cell and show the result in hours and minutes (no
time). It also need to be able to recognise the letter 'H' displayed i
the same cells instead of the time and display the time as '0:00'
Finally it needs to also be able to recognise the letter 'S' displaye
the same '0:00'. I belive this will require 3 fomulas and some kind o
linking Can this be done and can any one point me in the righ
direction to help, Better still forward me and example that I can pla
with.
Hopfully
Marti