Calculating the difference between hours

[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

 

[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.