calc labor hours required

[josh_m]

should be simple, but I can't figure it out
I have a sp.sheet that lists the required hours & required staff.
i want to calc the total labor hours
so I have the "In Time", "Out Time", "Staff Required", and "hours required"
example:
__A________B___________C_____________________D
1 in_______out__________# staff required________hours required
2 10:00_____19:00_______5

i want to calc the time between out and in, subtract 1 hour for lunch, then multiply to get total hours required
but when I enter this in D2:
=((B2-A2)-1)*C2
instead of the answer of 40 I am looking for, I get "#####"
i don't understand, please help

 

[barry houdini]

There as mismatch in your formula, if you want the result to be 40:00 then use this version

=((B2-A2)-1/24)*C2

format result cell as [h]:mm

or if you want the result to be 40

=((B2-A2)*24-1)*C2

format result cell as general or number

 

[josh_m]

thank you so very much, I have been feeling like a big dummy for an hour now.
that worked perfectly

 

[Andrew Fergus]

If you have entered 10:00 as a time then Excel stores this as a value of 0.416 and 18:00 as .7916, so subtracting 1 from the difference will give a value less than 1.

Try this instead and format the result as a number:
=(B2-A2-1/24)*C2*24

Andrew

Edit : too late!! I see the post has been asnwered......