CODEWITHSUNDEEP
exceltime
MK7
MK7

Reputation: 33

Excel Time Subtraction

I need to subtract the difference between two times in excel, but When I subtract time from one column to the other, the output is displayed as #####. I have formatted the cells containing the time as hh:mm:ss and the result as hh:mm. Any help would be greatly appreciated. Thanks in advance.

Upvotes: 0

Views: 86

Answers (1)

alex.pulver
alex.pulver

Reputation: 2125

##### is displayed if the cell content doesn't fit cell width. You need to increase the column width.

Upvotes: 1

Related Questions