| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Get excel to fractionalize hours.
I am making a time sheet for employees. Make 10:00 AM (one cell) to 12:30 PM
(2nd cell) = 2.5 hrs etc..... |
|
#2
|
|||
|
|||
|
=(B2-A2)*24
format as general Regards, Peo Sjoblom "ghoward777" wrote: I am making a time sheet for employees. Make 10:00 AM (one cell) to 12:30 PM (2nd cell) = 2.5 hrs etc..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
| How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2. | Excel Discussion (Misc queries) | |||
| excel template that can add up hours and cost per hour | Excel Discussion (Misc queries) | |||
| VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Linear Mode
