Problems calculating total hours
 

I am trying to create a wokr sheet that calculates the total hours worked in
a day utilizing hour:minute format. I've tried using =HOUR(B1-A1), and
although the hours get added the minutes don't and I do need a formula that
can calculate hour and minute and give me a total of how many there are in
that work day.

Hi
just subtract both values:
=B1-A1
and format as time
if your workin day can span midnigth use
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)

--
Regards
Frank Kabel
Frankfurt, Germany

LolaK wrote:
I am trying to create a wokr sheet that calculates the total hours
worked in a day utilizing hour:minute format. I've tried using
=HOUR(B1-A1), and although the hours get added the minutes don't and
I do need a formula that can calculate hour and minute and give me a
total of how many there are in that work day.