| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating date/time
Hope someone is able to help. This is to calculate the chargeable hours for a SAR boat in the water Date In| Time In| Date Out| Time Out|Conversion Time| Total Conversion time is value of ((DateOut+TimeOut)-(DateIn+TimeIn)*24) but needs to be rounded up to the nearest 0.1 i.e. 0-6=.1, 7-12=.2, 13-18=.3 etc. with a minimum chargeable time of 2 hours. Have tried ROUNDUP and CEILING but obviously not the correct way! Thanks Rick -- relaing ------------------------------------------------------------------------ relaing's Profile: http://www.excelforum.com/member.php...o&userid=29355 View this thread: http://www.excelforum.com/showthread...hreadid=490647 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
| date/time stamp | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Calculating date/time | Excel Discussion (Misc queries) | |||
Threaded Mode
