Excel Basement (@excelbasement) 's Twitter Profile
Excel Basement

@excelbasement

We provide services in the form of Training, Consultancy, Solutions, Coaching on Microsoft Office Products & Business Intelligence Tools.

ID: 2294911369

calendar_today16-01-2014 19:23:04

2,2K Tweet

35,35K Takipçi

0 Takip Edilen

Excel Basement (@excelbasement) 's Twitter Profile Photo
Excel Basement
@excelbasement

2 years ago

Calculating Total Working Hours & Total Working in Mins | Microsoft #Excel Method 1: Hours Worked | =IF(C5>B5,C5-B5,1-B5+C5) | Custom Formatting [H]:MM Method 2: Hours Worked | =MOD(C5-B5,1) | Custom Formatting [H]:MM For Mins Worked | =MOD(C5-B5,1) | Custom Formatting [MM]