Deducting minutes off running total

[Sid]

Hi There,

I am currenly trying to keep a tab of my staff's extra mins/hours worked
which they can use at any stage.

I currently have two columns a running total of additional hours worked and
a column showing hours deducted/ taken
I would like to deduct the hours taken from one cell against another e.g
(CELL H40) 3hrs - (CELL G46) 45mins = 2.15
How do i get it so that my (CELL H48) shows remaining hours left to use is
2.15?

I look forward to your response.

 

[Pete_UK]

Does H40 actually contain "3hrs" or does it contain the number 3 ?
Similarly, does G46 contain the number 45, or the text value
"45mins" ? What would H40 contain if the member of staff had accrued 3
hours and 30 minutes?

Pete

 

[David Biddulph]

Put 3:00 in H40 and 0:45 in G46, then in H48 put =H40-G46 and it will show
2:15.
Note that Excel uses a colon (not a decimal point) to separate hours from
minutes, so that 2:15 doesn't get confused with 2.15. 2.15 hours would be
2:09; 2:15 is 2.25 hours. If you want to convert 2:15 to 2.25, multiply by
24 and format as number or general, not as time.