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

On Dec 7, 2:11*pm, Sid wrote:
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.