Calculating Total Hours & Minutes Worked

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating Total Hours & Minutes Worked

FAQ

Thread Tools

Display Modes

04-12-2019, 01:52 PM

aaghd72

Windows 10 Calculating Total Hours & Minutes Worked

Office 2019

Novice

Join Date: Feb 2019

Posts: 15

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

Tags

excel 365

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

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