[RESOLVED] probably a child could answer this date/time question

I have created a new workbook but i don't normally use the macros excel provides. Well in this case i wanted to give it a shot instead of using vba.

The sheet is an employee schedule for a gas station. Each employee has 7 columns(son-sat) and 4 rows: Start, End, Hours, and which shift they are scheduled.
I want to be able to enter a time in start, a time in end, and have it total the hours automatically in Hours. Then i can have the 7 days added up into a total column. I have the cells formatted numeric date/time so i can subtract end from start, and this part works. The hours worked correctly adds up. The problem is that i can't total the days up!
Cells contain a value between 0 and .9999999 to represent a time and subtracting this returns the worked hours in the same format so i have to have the hours worked formatted as time also. Well i can't add these numbers up and get the correct answer for total hours worked in the week! it gives me all kinds of wierd results, even if formatted as a hour.

Anyone point me to a correct way to do this?

EDIT: DUH I was referencing the wrong cells. All i had to do when i referenced the CORRECT cells was multiply the result by 24.

Happy to have helped you :thumb: :D

You might want to Resolve the thread ;)

had to wait for phone to charge up again :) Was still getting some odd errors but when i went through and retyped the exact same formula a 2nd time it suddenly started working.