Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I am trying to do a time spread sheet, I am using hh:mm which works ok until I input a time that comes to a total of 9 hours when the total time reaches 9 hours it gives me 00:00 if I put eg 08:00 to 15:00 = 07:00 this is correct but if I put 08:00 to 17:00 should = 09:00 but gives me 00:00 I cannot work out what I am doing wrong could some one help. Please do in simple terms as I am self taught on excel and have worked out alsorts but if you get too technical I get lost. Thanks Frustrated Helen -- Helen Black |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions |