Calculating the difference between hours

S

Sambusa

First of all i would like to thank all of u & i appreciate ur help
I would like to explains some thing & ask about some thing

1\ The formula which i mentioned above workinf 90% ,
What i would like to ask about is EXCEL asume the holiday is Sat & Su
but i wan it to take Thu & Fri as a holiday

How can i do that pls ?

2\ the result of the formula is number ( 1.50 ) which is mean 1:30 ...
How can i change it to display 1:30 not 1.50


Waiting for ur reply now!!

Thanks for all
SAM
 
M

Myrna Larson

I didn't the the beginning of this thread, so I don't know which function you
are using, but for functions that assume weekends are Sat and Sun, just add 2
to the dates, i.e.

=NETWORKDAYS(A1+2,A2+2)

To convert hours to a time (which is stored as a fraction of a day), divide
the result by 24.
 

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

Days between 2 dates excluding Sundays only 1
Calculating occupational sick pay entitlement 0
Calculating the difference between hours 3
Simple Copy to and From Cells With IF statement. 3
White space above heading inconsistently applied 1
The Tueday prior to a holiday... 8
Calculating the difference between hours 2
Calculating the difference between hours 1

Top