Convertina number, say 110 hours into amount of hours

L

Lyndon

Hi, I want to make a sheet, whereby I will enter the amount of staff hours I can use that week and then it takes the scheduled staff hours away from it...
I have 110 hours to us
sheduling tells me I have scheduled 108:0
How do I convert 110 into a useable time format that I will then be able to subtract another time from ( I import this figure from a different page within the workbook as this is from a different calculatio

i
budget hours 110:0
scheduled hours 112:0
difference 2:0
Please forgive me if I havent been clear enough for you
 
N

Norman Harker

Hi Lyndon!

The trouble comes when scheduled > budget because Excel's 1900 date
system won't accept negative hours. You can switch to the 1904 date
system but this can impact elsewhere.

Alternatively use:

=(A1*24)-(B1*24)
Format General

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top