Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2019, 01:52 PM
aaghd72 aaghd72 is offline Calculating Total Hours & Minutes Worked Windows 10 Calculating Total Hours & Minutes Worked Office 2019
Novice
Calculating Total Hours & Minutes Worked
 
Join Date: Feb 2019
Posts: 16
aaghd72 is on a distinguished road
Question Calculating Total Hours & Minutes Worked

I can't figure out how to calculate the total of hours in Excel (365).

Begin End Hours
8:30 AM 4:16 PM 6:24:00 PM
8:00 AM 4:15 PM 6:00:00 AM
8:02 AM 3:52 PM 8:00:00 PM
6:00 AM 6:00 PM 12:00:00 AM
8:02 AM 2:10 PM 3:12:00 AM

Total Hours: 25095600=SUM(C4:C8)*24

Thanks in advance in assisting me with this total formula or the correct formatting.

K

Last edited by aaghd72; 04-12-2019 at 01:52 PM. Reason: Changed Excel Version
Reply With Quote
  #2  
Old 04-12-2019, 11:53 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Calculating Total Hours & Minutes Worked Windows 7 64bit Calculating Total Hours & Minutes Worked Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,431
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Please post a sample sheet ( no pics) with some data and expected results
Reply With Quote
  #3  
Old 04-13-2019, 03:32 AM
ArviLaanemets ArviLaanemets is offline Calculating Total Hours & Minutes Worked Windows 8 Calculating Total Hours & Minutes Worked Office 2016
Expert
 
Join Date: May 2017
Posts: 578
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

Simply sum column Hours, format the cell with formula like "[h]:mm:ss" (NB! Mark square brackets in formula, they are essential.), and there you are!

You also can use "[m]" (returns minutes), "[s]" (returns seconds), etc.
Reply With Quote
Reply

Tags
excel 365

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Total Hours & Minutes Worked Calculating multiple fields to calculate to the total hours stewbinson Excel 1 01-22-2017 10:18 PM
Calculating Total Hours & Minutes Worked Hours Worked - AM and PM franco9999 Excel 3 11-23-2016 09:25 AM
Calculating Total Hours & Minutes Worked how to find out hours worked between midnight and 6 am acorn Excel 2 10-15-2016 01:45 AM
Calculating Total Hours & Minutes Worked Very complicated calculation of total hours worked (PLEASE HELP) APreston Excel 1 05-08-2016 02:58 AM
Calculating Total Hours & Minutes Worked Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:11 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