| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Calculations using VBA.
Hi Excel Gurus,
I want to use Excel VBA to calculate daily working time. Both Start time and End time have to go by quarters of hours. It means that Starting at 09:05 is equivalent to 09:00. at 09:08 will be 09:15 etc. Since I'm a novice to Excel, I have some difficulties to add/subtract minutes from Time(). Then I have to subtract one (1) hour from the total time, for lunch break. How do I manipulate times in Excel? Thanks Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
![Eric[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
