| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
timecard
I need a simple formula.
Cell A1 is begin time and cell B1 is end time, both are entered in hours and minutes. I need the formula in C1 for the difference between the two in hours and minutes. Thank you SO SO Much -- bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
timecard
Assume in-out times entered in cols A and B from row2 down like this
In Out 8:00 18:00 etc Put in C2, copy down: =B2-A2 will return the required results -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vdmbqb" wrote: I need a simple formula. Cell A1 is begin time and cell B1 is end time, both are entered in hours and minutes. I need the formula in C1 for the difference between the two in hours and minutes. Thank you SO SO Much -- bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated Timecard | Excel Discussion (Misc queries) | |||
| Timecard question | Excel Worksheet Functions | |||
| Timecard | Excel Discussion (Misc queries) | |||
| Spreadsheet Timecard | Excel Discussion (Misc queries) | |||
| show me a filled in timecard example? | Setting up and Configuration of Excel | |||
Hybrid Mode
