Calculating multiple fields to calculate to the total hours
Hi,
This is should be a simple formula but my Excel skills are limited at best.
I have a table that has three columns: Days Hours Minutes. Each column has a value from 0 to unlimited.
I want to create a forth column that will calculate all three fields to show the total hours. For example, if my table had a row with column values Days-3, Hours-22 and Minutes-4 it the fourth column in my table would calculate to 94.4.
Any help would be greatly appreciated.
|