-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
time duration
-
A
Calculating Time Duration
Hi Everyone, I am so happy to have found this forum. I will try and explain my question as best as I can, but I’m a beginner user so please feel free to ask me questions to explain anything further. At work I am meant to calculate the durations between Arrival & Departures times for certain...- Avanz
- Thread
- time duration
- Replies: 7
- Forum: Excel Questions
-
B
Convert Cumulative Time / Time Duration to Text or String
I have a Cumulative Time field that formats as [h]:mm:ss that aggregates time in hours. I am needing to extract the time portion to convert it to a Text or String value. For example, a cumulative time total of 95:31:00 shows as "1/3/1900 11:31:00 PM" in the formula bar which is not what i want...- bemp87
- Thread
- time time and date time duration
- Replies: 4
- Forum: Excel Questions
-
E
What time is it right now (e.g. 2:15PM) & how do I calculate off that?
I'm working on a scheduling tool and I need to run a variety of time calculations. It's hard to explain all the nitty gritty details, but at a high level I'm doing a lot of back and forth conversion between decimals and time. I'm wondering what your thoughts are...do you try to do your math...- Ersh
- Thread
- scheduling time time calculations time duration
- Replies: 1
- Forum: Excel Questions
