#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Your fourth column can use a formula like:
=A1*24+B1+C1/60
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
calculate time |
Thread Tools | |
Display Modes | |
|
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 |