Hi Forum
Hope all is well, I have a question regarding subtracting and displaying the difference between two times in minutes even if the time crosses a day.
Excel Version: 2010
OS Level: Windows 7
Programming Experience: Novice
Background:
I have a user form with several progress bars that time the duration of tasks, some run in series and some in Parallel.
Question:
What I am trying to do is as follows.
I hope someone can get me started on this puzzle.
Many thanks
Regards
Rob
Hope all is well, I have a question regarding subtracting and displaying the difference between two times in minutes even if the time crosses a day.
Excel Version: 2010
OS Level: Windows 7
Programming Experience: Novice
Background:
I have a user form with several progress bars that time the duration of tasks, some run in series and some in Parallel.
Question:
What I am trying to do is as follows.
- When my application starts I get the current time AppStartTime
- As I call each sub I want to get CurrentTime = AppStartTime – Now displayed in minutes
- Also if I started my application at say 11:45 PM and it went into the next day the elapsed time in minutes accounts for this.
- Also how should I dimension the CurrentTime and AppStartTime (as double?)
I hope someone can get me started on this puzzle.
Many thanks
Regards
Rob