thanks but that gives me a #VALUE error. On another note, why 1440?
| Time Conversion.xls | |||
|---|---|---|---|
| A | |||
| 2 | How Long | ||
| 3 | Time that needs to be converted to minutes | ||
| 4 | 6:15 | ||
| 5 | 6:15 | ||
| 6 | 6:15 | ||
| 7 | 4:45 | ||
| 8 | 5:00 | ||
| 9 | 5:00 | ||
| 10 | 6:15 | ||
| 11 | 4:15 | ||
| 12 | 4:15 | ||
| 13 | 9:00 | ||
| 14 | 4:30 | ||
| 15 | 6:00 | ||
| 16 | 7:30 | ||
| 17 | 3:45 | ||
| 18 | 2:45 | ||
| 19 | 11:30 | ||
| 20 | 3:00 | ||
| 21 | 15:30 | ||
| 22 | 7:30 | ||
| 23 | 7:45 | ||
| 24 | 3:45 | ||
| 25 | 4:15 | ||
| 26 | 4:00 | ||
| 27 | :00 | ||
| 28 | :00 | ||
| 29 | 8:15 | ||
| 30 | :00 | ||
| 31 | :00 | ||
| 32 | :00 | ||
| 33 | 8:30 | ||
| 34 | :00 | ||
Time | |||
| Fluff.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | How Long | |||
| 2 | Time that needs to be converted to minutes | |||
| 3 | 06:15 | 375 | ||
| 4 | 06:15 | 375 | ||
| 5 | 06:15 | 375 | ||
| 6 | 04:45 | 285 | ||
| 7 | 05:00 | 300 | ||
| 8 | 05:00 | 300 | ||
| 9 | 06:15 | 375 | ||
| 10 | 04:15 | 255 | ||
| 11 | 04:15 | 255 | ||
| 12 | 09:00 | 540 | ||
| 13 | 04:30 | 270 | ||
| 14 | 06:00 | 360 | ||
| 15 | 07:30 | 450 | ||
| 16 | 03:45 | 225 | ||
| 17 | 02:45 | 165 | ||
| 18 | 11:30 | 690 | ||
| 19 | 03:00 | 180 | ||
| 20 | 15:30 | 930 | ||
| 21 | 07:30 | 450 | ||
| 22 | 07:45 | 465 | ||
| 23 | 03:45 | 225 | ||
| 24 | 04:15 | 255 | ||
| 25 | 04:00 | 240 | ||
| 26 | :00 | 0 | ||
| 27 | :00 | 0 | ||
| 28 | 08:15 | 495 | ||
| 29 | :00 | 0 | ||
| 30 | :00 | 0 | ||
| 31 | :00 | 0 | ||
| 32 | 08:30 | 510 | ||
| 33 | :00 | 0 | ||
Sheet5 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B3:B33 | B3 | =IFERROR(A3*1440,0) |
What number format are the values in column A in your data? I'm using this formula =IFERROR(B3*1440,0) and it returns a value of 0
Fluff, thanks for the help. I'm not sur why it's not working but in any case, I got the project working.
