To find out the total number of hrs worked in a week

P

pol

Hai all

I have two column in an excel sheet

A1 and B1

A1 cell contain total number of hrs in a day worked ie 6:30 (hh:mm) format
B1 cell contain number of days ie, 5

Please how can find out the total working hrs ie 6:30*5 ie total hrs worked
is 32.30 hrs .

Please give me a solution to arrive this answer

With thanks
Pol
 
P

Peo Sjoblom

=A1*B1

then (IMPORTANT) custom format the cell
as [h]:mm


If you need to calculate a total amount using an hourly rate use

=((A1*B1)*24)*rate

and format as currency or number

--


Regards,


Peo Sjoblom
 
P

pol

Thanks very much

Peo Sjoblom said:
=A1*B1

then (IMPORTANT) custom format the cell
as [h]:mm


If you need to calculate a total amount using an hourly rate use

=((A1*B1)*24)*rate

and format as currency or number

--


Regards,


Peo Sjoblom

pol said:
Hai all

I have two column in an excel sheet

A1 and B1

A1 cell contain total number of hrs in a day worked ie 6:30 (hh:mm)
format
B1 cell contain number of days ie, 5

Please how can find out the total working hrs ie 6:30*5 ie total hrs
worked
is 32.30 hrs .

Please give me a solution to arrive this answer

With thanks
Pol
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To calculate the working hrs of employee in excel 1
To find out number of sundays and saturdays in january month 3
to find out number off offdays of each employee 1
adding the total hours worked in 5 weeks 2
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
TimeSheet Using 100 Minutes & Rounding to .25 2
Calculate Total hours worked during workdays within given shift time. 2
Function that groups together Overtime hours by 7.5 hrs 2

Top