Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum hours in Excel Macro VBA
Hi I need help to sum hours in Excel VBA. Before I just simply made
the macro create a formula to sum the hours but now the users want to the total working hours for several months and the string created in the macro is too long and the macro errors out. Is it possible that someone can post some sample code to help me out Thank You |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum hours in Excel Macro VBA
summing hours is no different than summing anything else but you confuse me
when you say the total working hours for several months and the string created in the macro is too long and the macro errors out. why are you referring to strings when summing? Can we see a snippet of the code that 'errors out' Mike "Tazo" wrote: Hi I need help to sum hours in Excel VBA. Before I just simply made the macro create a formula to sum the hours but now the users want to the total working hours for several months and the string created in the macro is too long and the macro errors out. Is it possible that someone can post some sample code to help me out Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours | Excel Discussion (Misc queries) | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |