Microsoft Office Forums Calculating Total Hours & Minutes Worked
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-12-2019, 01:52 PM
 aaghd72 Windows 10 Office 2019 Novice Join Date: Feb 2019 Posts: 16
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
#2
04-12-2019, 11:53 PM
 Pecoflyer Windows 7 64bit Office 2010 64bit Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,387

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.
#3
04-13-2019, 03:32 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 455

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.

 Tags excel 365

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post stewbinson Excel 1 01-22-2017 10:18 PM franco9999 Excel 3 11-23-2016 09:25 AM acorn Excel 2 10-15-2016 01:45 AM APreston Excel 1 05-08-2016 02:58 AM Snvlsfoal Excel 1 08-11-2011 05:54 AM

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

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top