D
Dargo
I have a spreadsheet that, amongst others, show the columns below. Thes
are vehicles (fleet no) that have broken down, the time they wer
unavaiable,and the round (area of the city) they were from. I alread
have a cell that shows sum of total time using =SUM(F1:F77) that work
fine. However I've now added auto filter to the date, round and flee
columns and want to total the hours from the filtered list. I have rea
some of the advice on this forum and have tried =SUBTOTAL(9,F1:F18) bu
it returns a decimal, and not total hours and minutes. I'm probabl
(obviously) doing something stupid. Can anyone help
Thanks
Alan
A B C D E
F
Date Round Fleet No Stop Repaired Total Time
1 02 March G 5008 09:15 10:05 00:50
2 02 March B 5008 10:07 11:05 00:58
3 02 March G 5008 11:15 12:30 01:15
4 04 March G 5009 08:00 09:30 01:3
are vehicles (fleet no) that have broken down, the time they wer
unavaiable,and the round (area of the city) they were from. I alread
have a cell that shows sum of total time using =SUM(F1:F77) that work
fine. However I've now added auto filter to the date, round and flee
columns and want to total the hours from the filtered list. I have rea
some of the advice on this forum and have tried =SUBTOTAL(9,F1:F18) bu
it returns a decimal, and not total hours and minutes. I'm probabl
(obviously) doing something stupid. Can anyone help
Thanks
Alan
A B C D E
F
Date Round Fleet No Stop Repaired Total Time
1 02 March G 5008 09:15 10:05 00:50
2 02 March B 5008 10:07 11:05 00:58
3 02 March G 5008 11:15 12:30 01:15
4 04 March G 5009 08:00 09:30 01:3
