| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
Trying to set up a simple time schedule.
Thought I knew how to do this. Beginning time - End time = hours & minutes worked Please help Thanks Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Wouldn't it be ending time - beginning time? There are days when I have quit
even before I started but that probably does not apply in this case. -- HTH... Jim Thomlinson "Window Guy" wrote: Trying to set up a simple time schedule. Thought I knew how to do this. Beginning time - End time = hours & minutes worked Please help Thanks Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Eric,
You want to use the following VBA End_Time - Begin_Time - (End_Time<Begin_Time) This assumes you have times without dates. If you have dates and times, just use End_Time - Begin_Time In both cases, format the cell with a custom format of [hh]:mm or [hh]:mm:ss -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Window Guy" wrote in message ... Trying to set up a simple time schedule. Thought I knew how to do this. Beginning time - End time = hours & minutes worked Please help Thanks Eric |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Hi Eric
See Chip Pearson's site http://www.cpearson.com/excel/overtime.htm See also the links on the bottom of this page -- Regards Ron de Bruin http://www.rondebruin.nl "Window Guy" wrote in message ... Trying to set up a simple time schedule. Thought I knew how to do this. Beginning time - End time = hours & minutes worked Please help Thanks Eric |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Thank you Ron,
Excellent info and formulas. Appricate it very much. Eric "Ron de Bruin" wrote in message ... Hi Eric See Chip Pearson's site http://www.cpearson.com/excel/overtime.htm See also the links on the bottom of this page -- Regards Ron de Bruin http://www.rondebruin.nl "Window Guy" wrote in message ... Trying to set up a simple time schedule. Thought I knew how to do this. Beginning time - End time = hours & minutes worked Please help Thanks Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
