| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003
I am trying to create a formula to determine work hours.
Date & time is captured as ccyy/mm/dd hh:mm (start date / time - end date / time) I also created a file for public holidays. -- Andrew |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003
hi
see these sites http://www.cpearson.com/Excel/datetime.htm#AddingTimes http://www.cpearson.com/Excel/overtime.htm regards FSt1 "Andrew" wrote: I am trying to create a formula to determine work hours. Date & time is captured as ccyy/mm/dd hh:mm (start date / time - end date / time) I also created a file for public holidays. -- Andrew |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003
Thank You this helped
-- Andrew "FSt1" wrote: hi see these sites http://www.cpearson.com/Excel/datetime.htm#AddingTimes http://www.cpearson.com/Excel/overtime.htm regards FSt1 "Andrew" wrote: I am trying to create a formula to determine work hours. Date & time is captured as ccyy/mm/dd hh:mm (start date / time - end date / time) I also created a file for public holidays. -- Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
| opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Linear Mode
