Hi,
On a mission to prove my employers wrong as they say I owe them hours. Our rota software can export data to an excel spreadsheet, so that's what I've done.
I'm trying to calculate the totals of a partial column of hours worked. The time worked appears as, for example, 11:15 (11 hours, 15 mins) and there is a line for every day of the year.
I've tried formatting the cells in the column to time and also custom/hh:mm, and also the cells in the column I want the answer to appear.
I've tried this formula but the answer appears as zero: =sum(F3:F375) which isn't working as the answer appears as 00:00. I get the correct result if I do =f3+f4+f5.... etc.
Not all lines have a data entry - rest days, leave, training, overtime, etc and these appear in separate columns which I can calculate later. Could this be the issue? That said, the same happens when I do the sum of 2 consecutive lines - ie, =sum(f3:f4) where there is data entry to calculate. Do I need a different formula as I'm calculating time and non-decimal figures? A quick Google suggests I'm along the right track.
I have to go back 3 financial years, so if there's a quick way to do this, I'd be most grateful.
Thanks in advance,
FB..
On a mission to prove my employers wrong as they say I owe them hours. Our rota software can export data to an excel spreadsheet, so that's what I've done.
I'm trying to calculate the totals of a partial column of hours worked. The time worked appears as, for example, 11:15 (11 hours, 15 mins) and there is a line for every day of the year.
I've tried formatting the cells in the column to time and also custom/hh:mm, and also the cells in the column I want the answer to appear.
I've tried this formula but the answer appears as zero: =sum(F3:F375) which isn't working as the answer appears as 00:00. I get the correct result if I do =f3+f4+f5.... etc.
Not all lines have a data entry - rest days, leave, training, overtime, etc and these appear in separate columns which I can calculate later. Could this be the issue? That said, the same happens when I do the sum of 2 consecutive lines - ie, =sum(f3:f4) where there is data entry to calculate. Do I need a different formula as I'm calculating time and non-decimal figures? A quick Google suggests I'm along the right track.
I have to go back 3 financial years, so if there's a quick way to do this, I'd be most grateful.
Thanks in advance,
FB..