formula for time to 10th of an hour

[cblincoln43]

Im looking for how excell turns minutes into tenth of an hour. As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.
Im putting in cell..A1=5.5p,(pm)...in cell B1=2.0a,(am). Then in cell C1= the total elapsed time. That will make it past midnight.
.....B1=2.0a..(-)..A1=5.5p....C1=8.5hours.

[ This Message was edited by: cblincoln43 on 2002-04-04 09:21 ]

[ This Message was edited by: cblincoln43 on 2002-04-04 09:22 ]

[Mark W.]

As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.

Can't be done with formatting.

[Yogi Anand]

On 2002-04-04 09:20, cblincoln43 wrote:
Im looking for how excell turns minutes into tenth of an hour. As in; if cell A1=5:30pm then cell A1 would read 5.5p or pm.
Im putting in cell..A1=5.5p,(pm)...in cell B1=2.0a,(am). Then in cell C1= the total elapsed time. That will make it past midnight.
.....B1=2.0a..(-)..A1=5.5p....C1=8.5hours.

[ This Message was edited by: cblincoln43 on 2002-04-04 09:21 ]

[ This Message was edited by: cblincoln43 on 2002-04-04 09:22 ]

Hi cblincoln43:
cell A2 ... 5:30 PM
cell B2 ... 2:00 AM

cell c2 ... =IF(B2-A2<0,B2-A2+1,B2-A2)*24
format cell C2 as CUSTOM 0.00 "hours"
result

8.50 hours





_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 14:08 ]

[cblincoln43]

Does this mean i have to use the 12hour clock as an in 5:00pm,, not tenthsas in 5.0 pm or(p)