ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worktime function (https://www.excelbanter.com/excel-programming/333205-worktime-function.html)

evgny

worktime function
 
ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]
I have a worktimefunction selection (R[-1]C is date and time (18,03,05
07:01:01)
selection RC[-1] is houers add to date
and time.
Some time I add hollydays as this:
ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]+1 or 15 or what ever,
this I do manualy. I want do du this by VBA, I have created a smal calender
with difrent hollysdays.
I have writen a sub wher I do evrything inside Vba and put the resalt to
the cell, but then I dont have the function only the resalt in the cell.

I also have writen a sub wher
ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]+Klokkeslett!R12C4"
but when I add +1 or.... it taks long time for the function to calculate,
sometime it never stop.
Is there a way to put the +1 or...... direct to the function insted bye
VBA????
Sorry, may spelling is bed.

Regards
Yngve


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com