Calculating the difference between hours
 

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

--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496
View this thread: http://www.excelforum.com/showthread.php?threadid=26588

Calculating the difference between hours
 

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.


On Wed, 6 Oct 2004 09:17:52 -0500, Sambusa
wrote:


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 & Sun
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
SAMI