| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the number of hours between 11:00 am & 4:00 pm
The INT function will return an integer value. If you want to display
fractions of an hour then just remove that and format the cell as number with 2 dp, i.e.: =(B1-A1)*24 Hope Bob doesn't mind me taking this up - he's probably in bed by now !! <bg Pete nospam wrote: Bob Phillips wrote: =int((B1-A1)*24) I tried this with 9:45 AM start time and 12:00 PM end time and it calculates 2 hrs not 2.25. Any way to make it do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate hours worked | New Users to Excel | |||
| Is it possible to convert a number into hours and minutes | Excel Worksheet Functions | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| Creat a formula to calculate working hrs according to number of da | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
Hybrid Mode
