| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating the difference between hours | Excel Worksheet Functions | |||
| Calculating the difference between hours | Excel Programming | |||
| Calculating the difference between hours | Excel Programming | |||
| Calculating the difference between hours | Excel Programming | |||
| Calculating the difference between hours | Excel Programming | |||
![Sambusa[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
