Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula w/ Time format
I am trying to create a time sheet with in and out columns. The in / out
columns are formatted as time. The "total" column needs to be the total number of hours - I am unable to get the arithmetic to work. Thankyou. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula w/ Time format
If In = 8:00 AM and Out = 5:00 PM, then (5:00 PM - 8:00 AM) * 24 will yield 9
hours. The reason being is that Excel stores time as fractions of a day. The calculation above is really (17/24 - 8/24) * 24 = 9/24 * 24/1 = 9 hours. Make sure the cell in which you are performing the calculation is formatted as numbers, not time. -- Brevity is the soul of wit. "tanya" wrote: I am trying to create a time sheet with in and out columns. The in / out columns are formatted as time. The "total" column needs to be the total number of hours - I am unable to get the arithmetic to work. Thankyou. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula w/ Time format
If the first 'IN' is in cell A1 and the first 'OUT' is in cell B1, the second
'IN' is in cell C1 and the second 'OUT' is in cell D1 where the total hours will be in cell E1, try the following. IN CELL E1 =(B1-A1)+E1-D1 make sure your 'IN' and 'OUT' cells are formatted for time. enter your time for AM as #:## and for PM as #:## pm (don't forget the space between the last number and the pm "tanya" wrote: I am trying to create a time sheet with in and out columns. The in / out columns are formatted as time. The "total" column needs to be the total number of hours - I am unable to get the arithmetic to work. Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel data in text, wont update to time format | Excel Discussion (Misc queries) | |||
Format number to Time in Excel? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) |