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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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

All times are GMT -7. The time now is 04:35 PM.


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