How to find out hrs and minitus

P

pol

Hi ,

I have the following data

Company working hours (l_dec_cmp_hrs) = 8.00
Staff latetime hrs (l_dec_latetime) = .10

The effective working hrs should be = 7.50 .
Please can anybody advice me with a logic to get the answer .
 
S

Sean Timmons

you can either change the format to show 8:00 and :10, then do a simple
subtraction, or you can do somethign like:

=A1-(60-A2)
 

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 find out time 5
Outlook meeting location auto prompts with a suggestion list - need to disable 0
relective formula 0
formula or calculation for adding negative hour and positive hours 1
to find diffrence in time 3
To calculate the working hrs of employee in excel 2
help cumulative hrs 1
Pull Data With IF Statement And Sort. 1

Top