cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
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
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