-
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.
duration
-
T
Calculate Duration between dates and return results in three groups
Hi. Using Excel 2003, I have two columns of start/end dates, both in mm/dd/yyyy format Column A is a start date Column B is an end date I'd like to calculate the duration between ColumnA and ColumnB and return the results as shown in one of the four duration groups below. Duration group...- typewriterguy
- Thread
- duration group dates
- Replies: 1
- Forum: Excel Questions
-
S
Formula and format for time duration
Employees are entering their daily time spent on activities in minutes: Monday Act A: 45 Act B: 120 Act C: 30 How do I get a daily total that would look like this: 3:15 (to show 3 hours and 15 mins), instead of 3.25 Thanks!- skarp
- Thread
- duration time
- Replies: 5
- Forum: Excel Questions
-
N
Charting Duration of Events
Hello, I am trying to chart some data that contains events that last for a random duration. Lets say I have some data like this (for 20 seconds): seconds, value 0 OFF 1 OFF 2 OFF 3 ON 4 ON 5 ON 6 OFF 7 OFF 8 ON 9 ON 10 ON 11 ON 12 ON 13 OFF 14 OFF 15 OFF 16 ON 17 ON 18 ON 19 ON 20 ON It is kind...- Nugget
- Thread
- duration line chart signal
- Replies: 4
- Forum: Excel Questions
