I have a spreadsheet calculating hours worked, based on time of day start and time of day end, expressed as 08:00 or 10:00 or 12:00 hours. I would like to sum these columns and then divide by 80 to calculate FTE. I'm having trouble because the hours are expressed as time and not just a number. Any help is appreciated!
-
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.
jtakw
Well-known Member
- Joined
- Jun 29, 2014
- Messages
- 7,245
- Office Version
- 2016
- Platform
- Windows
Changing the cell format to [H] really doesn't make any difference for your SUM, that only changes the way the Data is displayed in the cell, so it Only matters on how you want to See your data, but does nothing for the SUM formula.
If you have formulas putting the "" in the cells, that will give you the #VALUE! error, there are different ways to work around it.
One way, if you have Headers for the cells you want to sum, this also simplifies the formula and makes it easier to maintain, you can try something like,
I used "Hours" as the Header, please show what your actual Header is, so the formula can be adjusted accordingly:
=SUMIF(G1:BU1,"Hours",G7:BU7)*24/80
If you have formulas putting the "" in the cells, that will give you the #VALUE! error, there are different ways to work around it.
One way, if you have Headers for the cells you want to sum, this also simplifies the formula and makes it easier to maintain, you can try something like,
I used "Hours" as the Header, please show what your actual Header is, so the formula can be adjusted accordingly:
=SUMIF(G1:BU1,"Hours",G7:BU7)*24/80
Last edited:
Upvote
0
Similar threads
- Question
- Question
