Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi Hoping someone can help
Trying to measure downtime.
Got a list of colleague names column E
Date issue reported cilumn F
Downtime in mins column M
Managed to work out total no issues & downtime per colleague and total no issues / downtime for yesterday & today , but struggling to identify no issues and downtime for today & yesterday per colleague ( colleague names in column Q, No issues reported today column T, total downtime today column u
Formula for no issues reported by colleague column T
=COUNTIFS($F2:$F1000,"=TODAY()",$E2:$E1000,Q2) but getting #NAME?
Also need a SUM formula to sum up the total downtime for each colleague for today ( columns as per anove colleague names in column E, dates column F , downtime values column M, colleague lookup column Q
Trying to measure downtime.
Got a list of colleague names column E
Date issue reported cilumn F
Downtime in mins column M
Managed to work out total no issues & downtime per colleague and total no issues / downtime for yesterday & today , but struggling to identify no issues and downtime for today & yesterday per colleague ( colleague names in column Q, No issues reported today column T, total downtime today column u
Formula for no issues reported by colleague column T
=COUNTIFS($F2:$F1000,"=TODAY()",$E2:$E1000,Q2) but getting #NAME?
Also need a SUM formula to sum up the total downtime for each colleague for today ( columns as per anove colleague names in column E, dates column F , downtime values column M, colleague lookup column Q