| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
Setting up a time sheet
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
Don't use the =text() function.
Just do the subtraction and format the cell: h:mm ps. It's better to write your question in the body of the message--not just in the subject. be013fc wrote: Setting up a time sheet -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
=L9-K9
"be013fc" wrote: Setting up a time sheet |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
L9-K9
and format the cell to below from FormatCellsCustom [h]:mm If this post helps click Yes --------------- Jacob Skaria "be013fc" wrote: Setting up a time sheet |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
Hi,
You might also what to look at some free Excel timesheet templates at: http://office.microsoft.com/en-us/te...172771033.aspx -- If this helps, please click the Yes button. Cheers, Shane Devenshire "be013fc" wrote: Setting up a time sheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Data entry "+" results in "294" in XLS | Excel Discussion (Misc queries) | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
