| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM OF TIME
hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM OF
= 4.75HRS? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM OF TIME
Let's say
A1 = 2.00 PM B1 = 6:45 PM C1 =(B1-A1)*24 Format C1 as a number with 2 decimal places "OSCAR" wrote in message ... hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM OF = 4.75HRS? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM OF TIME
nOW HOW WOULD aDD ONE MORE HOUR FROM D1?
"Barb Reinhardt" wrote: Let's say A1 = 2.00 PM B1 = 6:45 PM C1 =(B1-A1)*24 Format C1 as a number with 2 decimal places "OSCAR" wrote in message ... hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM OF = 4.75HRS? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM OF TIME
tHANKS i GOT THE ANSWER TO THE ADD.
"Barb Reinhardt" wrote: Let's say A1 = 2.00 PM B1 = 6:45 PM C1 =(B1-A1)*24 Format C1 as a number with 2 decimal places "OSCAR" wrote in message ... hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM OF = 4.75HRS? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| time differences in a column | Excel Worksheet Functions | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
