| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to give the number of hours
I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below? a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to give the number of hours
The formula for C1 would be =(B1-A1)*24
"force530" wrote: I need a function that will result in the number of hrs between two times. If there is no data, then blank. How do I get the result in C1 as in below? a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to give the number of hours
On Thu, 21 Sep 2006 13:01:02 -0700, force530
wrote: I need a function that will result in the number of hrs between two times. If there is no data, then blank. How do I get the result in C1 as in below? a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5 With the data entered as above but with no double quote marks: C1: =(B1-A1)*24 Format as General or Number with desired number of decimal places --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to give the number of hours
Thanks to both of you ... it worked.
"Ron Rosenfeld" wrote: On Thu, 21 Sep 2006 13:01:02 -0700, force530 wrote: I need a function that will result in the number of hrs between two times. If there is no data, then blank. How do I get the result in C1 as in below? a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5 With the data entered as above but with no double quote marks: C1: =(B1-A1)*24 Format as General or Number with desired number of decimal places --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| Help with Sum if (or something else not sure) | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
Linear Mode
