Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2017, 09:36 PM
stewbinson stewbinson is offline Calculating multiple fields to calculate to the total hours Windows 8 Calculating multiple fields to calculate to the total hours Office 2013
Novice
Calculating multiple fields to calculate to the total hours
 
Join Date: Jan 2017
Posts: 1
stewbinson is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-22-2017, 10:18 PM
macropod's Avatar
macropod macropod is offline Calculating multiple fields to calculate to the total hours Windows 7 64bit Calculating multiple fields to calculate to the total hours Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,566
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Your fourth column can use a formula like:
=A1*24+B1+C1/60
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
calculate time

Thread Tools
Display Modes


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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft