Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-12-2019, 01:52 PM
aaghd72 aaghd72 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2019
Posts: 15
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,367
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 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 offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 426
ArviLaanemets 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 multiple fields to calculate to the total hours stewbinson Excel 1 01-22-2017 10:18 PM
Hours Worked - AM and PM franco9999 Excel 3 11-23-2016 09:25 AM
how to find out hours worked between midnight and 6 am acorn Excel 2 10-15-2016 01:45 AM
Very complicated calculation of total hours worked (PLEASE HELP) APreston Excel 1 05-08-2016 02:58 AM
Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM


All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft