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.