Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number of hours needed
I appreciate your previous help with this time sheet. Now I have total hours
worked. I want to create a formula to show hours needed to work out of 300. So I tried =300-F23 (which is the cell where my total hours worked is) I get a very large number. F23 is formatted as [h]:mm;@ and so is my total cell (F27). I tried formatting F27 as a number and that was wrong too. Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number of hours needed
Try
=(300/24)-F23 (format as [hh]:mm 1 = 24 hours in Excel so 300 would be 300*24 hours, thus the number would be large so before you do any calculation with decimal and Excel hours you need to convert them, either the 1st formula I posted or =300-(F23*24) formatted as General note that the latter will give you the answer in decimals -- Regards, Peo Sjoblom "xololady" wrote in message ... I appreciate your previous help with this time sheet. Now I have total hours worked. I want to create a formula to show hours needed to work out of 300. So I tried =300-F23 (which is the cell where my total hours worked is) I get a very large number. F23 is formatted as [h]:mm;@ and so is my total cell (F27). I tried formatting F27 as a number and that was wrong too. Thank you for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
number of hours needed
Try it like this:
=300-(F23*24) Format the cell as GENERAL or NUMBER -- Biff Microsoft Excel MVP "xololady" wrote in message ... I appreciate your previous help with this time sheet. Now I have total hours worked. I want to create a formula to show hours needed to work out of 300. So I tried =300-F23 (which is the cell where my total hours worked is) I get a very large number. F23 is formatted as [h]:mm;@ and so is my total cell (F27). I tried formatting F27 as a number and that was wrong too. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Formula needed for dividing hours by numbers | Excel Discussion (Misc queries) | |||
how do i calculate the number of hours between 11:00 am & 4:00 pm | Excel Worksheet Functions | |||
Number conversion to Hours | Excel Worksheet Functions | |||
Number of hours worked between 18:00 and 06:00 | Excel Worksheet Functions |