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 knowing that there may be some in my spreadsheet which go over to hours.
Kathy
1 Reply
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.
