Forum Discussion
Subtracting time
I am having difficulty creating a formula. I need to subtract time 09:30 09:57 where these would be in two different columns and I need to know the time difference. and also kn...
If you have your 9:30 in Cell A1
Your 9:57 in cell B1
Then entering the formula below in Cell C1 will give you the result :27
=B1-A1
If the first value is 7:30 instead, then the result is 2:27
If that's not what you're looking for please come back with a more complete description of what kind of result you're expecting.