Calculating multiple fields to calculate to the total hours

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating multiple fields to calculate to the total hours

01-22-2017, 10:18 PM

macropod

Windows 7 64bit Calculating multiple fields to calculate to the total hours

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Your fourth column can use a formula like:
=A1*24+B1+C1/60

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating the “total” based on “salary” value and its “type” (multiple IF),	Jamal NUMAN	Excel	4	07-05-2016 12:34 AM
Very complicated calculation of total hours worked (PLEASE HELP)	APreston	Excel	1	05-08-2016 02:58 AM
Total Hours * hourly rate	medavidcook	Excel	7	06-04-2015 09:29 AM
Adding of times total to be in hours	jen0dorf	Excel	4	06-20-2014 11:53 PM
Timesheet and calculating over 40 hours	brandon0409	Excel	1	04-26-2014 12:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.