| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help calculating time
I have a problem displaying the time (minutes) correctly beyond 60 minutes.
Fox example: B29 = 3/17/09 4:10 PM - cell formated as DATE and TYPE 3/17/09 4:10 PM C29 = 3/19/09 10:05 PM - cell formated as DATE and TYPE 3/19/09 10:05 PM D29 will display 24 hours 1075 minutes. Formula in D29 =INT(C29-B29)*24& "hours "&INT(MOD((C29-B29),1) & minutes" 2 things that I would like to have display in D29 a) is X days X hours X minutes. b) Total time to exclude the weekends as it is not a business day for us. I know that I'm mssing something here but do not know what exactly. Can anyone help. -- tech1NJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
| Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Threaded Mode
