Microsoft Office Forums Calculating Total Hours & Minutes Worked

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
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet ( no pics) with some data and expected results
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 04-13-2019, 03:32 AM
ArviLaanemets ArviLaanemets is online now Calculating Total Hours & Minutes Worked Windows 8 Calculating Total Hours & Minutes Worked Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
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


All times are GMT -7. The time now is 06:02 AM.


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