Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel calculate time increments in a formula?
I want to have a formula in my time sheets that calculate the incriments of
time. For instance: If the time on a project site is: Start Time End Time Project Hours 1:15 pm 6:45 pm 5.75 (<i want this to calculate automaticlly to remove human error. Is that possible?) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel calculate time increments in a formula?
=(D2-C2)*24
=5.5 -- Don Guillett SalesAid Software "lmunzen" wrote in message ... I want to have a formula in my time sheets that calculate the incriments of time. For instance: If the time on a project site is: Start Time End Time Project Hours 1:15 pm 6:45 pm 5.75 (<i want this to calculate automaticlly to remove human error. Is that possible?) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel calculate time increments in a formula?
I have a formula written somewhere that will do this, if required
beyond one day (ie. starts on thursday at 3pm and ends monday at 2pm, will calculate working hours and exclude weekends/non working hours etc). Let me know if you need it Don Guillett wrote: =(D2-C2)*24 =5.5 -- Don Guillett SalesAid Software "lmunzen" wrote in message ... I want to have a formula in my time sheets that calculate the incriments of time. For instance: If the time on a project site is: Start Time End Time Project Hours 1:15 pm 6:45 pm 5.75 (<i want this to calculate automaticlly to remove human error. Is that possible?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Excel formula and Time... | Excel Worksheet Functions | |||
How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |