![]() |
|
#1
|
|||
|
|||
|
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. |
| Tags |
| calculate time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Calculating the “total” based on “salary” value and its “type” (multiple IF),
|
Jamal NUMAN | Excel | 4 | 07-05-2016 12:34 AM |
Very complicated calculation of total hours worked (PLEASE HELP)
|
APreston | Excel | 1 | 05-08-2016 02:58 AM |
Total Hours * hourly rate
|
medavidcook | Excel | 7 | 06-04-2015 09:29 AM |
Adding of times total to be in hours
|
jen0dorf | Excel | 4 | 06-20-2014 11:53 PM |
Timesheet and calculating over 40 hours
|
brandon0409 | Excel | 1 | 04-26-2014 12:18 AM |