| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cells to calculate hours and minutes taken to complete task
Hi
I have the following calculation in my column E: =((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24 Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss Currently my results in column E return 0.17 which equates to 10 minutes - I really want it to show 10 minutes and not 0.17 Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA | Excel Worksheet Functions | |||
| how to calculate the hours and minutes in excel | Excel Discussion (Misc queries) | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| How to calculate days:Hours:Minutes: | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
Threaded Mode
