Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-13-2019, 03:32 AM
ArviLaanemets ArviLaanemets is offline Calculating Total Hours & Minutes Worked Windows 8 Calculating Total Hours & Minutes Worked Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
 

Tags
excel 365



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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 PM.


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