Formula for adding hours worked from one start time to another (am/pm)

%3CLINGO-SUB%20id%3D%22lingo-sub-1548401%22%20slang%3D%22en-US%22%3EFormula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548401%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20time%20user%20of%20the%20community.%20Probably%20a%20very%20simple%20question%20but%2C%20how%20do%20I%20caculate%20the%20total%20hours%20when%2C%20in%20Cell%20%231%20I%20have%20the%20start%20time%20(e.g.%208%3A00%20am)%20and%20the%20other%20cell%20I%20have%20the%20end%20time%20(5%20pm.)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548401%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554472%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741357%22%20target%3D%22_blank%22%3E%40Northwest_Plumbing%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20%3D%20endTime%20-%20startTime%3C%2FP%3E%0A%3CP%3Eassuming%20both%20are%20for%20the%20same%20day%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554516%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20I%20tried%20that%20and%20here%20is%20the%20result%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22346%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2297%22%3ETime%20In%3C%2FTD%3E%3CTD%20width%3D%2261%22%3EBreaks%3C%2FTD%3E%3CTD%20width%3D%22101%22%3ETime%20Out%3C%2FTD%3E%3CTD%20width%3D%2287%22%3EHours%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8%3A00%3A00%20AM%3C%2FTD%3E%3CTD%3E0.50%3C%2FTD%3E%3CTD%3E6%3A00%3A00%20PM%3C%2FTD%3E%3CTD%3E-0.42%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EIt%20should%20total%3A%2010%20hrs%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554591%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741357%22%20target%3D%22_blank%22%3E%40Northwest_Plumbing%3C%2FA%3E%26nbsp%3B%2C%20change%20the%20number%20format%20to%20%22hh%22%20to%20get%20the%20time%20in%20hours.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554612%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554612%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Anthony.%20That%20helped%20to%20make%20it%20look%20better%20but%2C%20I%20still%20haven't%20found%20a%20formula%20to%20add%20the%20hours%20from%20start%20time%20to%20end%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555375%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741357%22%20target%3D%22_blank%22%3E%40Northwest_Plumbing%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOperate%20with%20time%20as%20with%20any%20numbers.%20Actually%20in%20Excel%20days%20are%20equivalent%20of%20integer%20numbers%20where%201%20is%20Jan%2001%2C%201900%20and%20time%20is%20decimal%20part%20of%20the%20number%20where%201%20hour%20is%20equal%20to%201%2F24.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20apply%20time%20format%20to%20the%20result%20and%20take%20into%20account%20time%20could%20not%20be%20negative.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555394%22%20slang%3D%22de-DE%22%3ESubject%3A%20Formula%20for%20adding%20hours%20worked%20from%20one%20start%20time%20to%20another%20(am%2Fpm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555394%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741357%22%20target%3D%22_blank%22%3E%40Northwest_Plumbing%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeven%20if%20the%20solution%20of%20the%20others%20are%20more%20elegant%20..%20I%20send%20my%20small%20solution%20for%20quick%20processing%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3Esry%20in%20advance%20for%20my%20additional%20intervention%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20solved%20your%20problem%20with%20this%20solution%2C%20please%20mark%20it%20as%20the%20correct%20answer%20so%20that%20others%20can%20also%20get%20this%20information.%20%3CBR%20%2F%3E%20If%20this%20is%20not%20what%20you%20are%20looking%20for%2C%20please%20give%20us%20a%20quick%20feedback.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

First time user of the community. Probably a very simple question but, how do I caculate the total hours when, in Cell #1 I have the start time (e.g. 8:00 am) and the other cell I have the end time (5 pm.)?

6 Replies
Highlighted

@Northwest_Plumbing 

That's = endTime - startTime

assuming both are for the same day

Highlighted

@Sergei Baklan 

Thank you, I tried that and here is the result: 

Time InBreaksTime OutHours
8:00:00 AM0.506:00:00 PM-0.42

It should total: 10 hrs??

Highlighted

@Northwest_Plumbing , change the number format to "hh" to get the time in hours. 

Highlighted

@TheAntony 

Thank you Anthony. That helped to make it look better but, I still haven't found a formula to add the hours from start time to end time?

Highlighted

@Northwest_Plumbing 

Operate with time as with any numbers. Actually in Excel days are equivalent of integer numbers where 1 is Jan 01, 1900 and time is decimal part of the number where 1 hour is equal to 1/24.

 

Just apply time format to the result and take into account time could not be negative.

Highlighted

@Northwest_Plumbing 

 

even if the solution of the others are more elegant .. I send my small solution for quick processing

sry in advance for my additional intervention

 

If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information.
If this is not what you are looking for, please give us a quick feedback.

 

 

Nikolino
I know I don't know anything (Socrates)