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 2
Help to derive a formula from the given example 1
Calculate Total hours worked during workdays within given shift time. 0
To find out number of sundays and saturdays in january month 3
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
adding the total hours worked in 5 weeks 2
to find out number off offdays of each employee 1
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2

Top