Test_book.zip 2.04KB 186 downloads
Excel
Started by
SpaceCowboy706
, Apr 15 2007 07:56 PM
#1
Posted 15 April 2007 - 07:56 PM
Test_book.zip 2.04KB 186 downloads
#2
Posted 15 April 2007 - 08:21 PM
Look at this. I played with the "Round" function, but since the field is formatted as time, I couldn't get it.
Attached Files
Edited by LindaGail, 15 April 2007 - 08:26 PM.
#3
Posted 16 April 2007 - 06:59 AM
SpaceCowboy,
Try this.
=FIXED(C7*24,0)*2
Fixed(xxx, 0) rounds to the nearest integer
C7*24 converts your hh:mm to decimal hours (you need to format the cell to 0.00 to see the value)
*2 2 inspections per hour
HTH
dsm
Try this.
=FIXED(C7*24,0)*2
Fixed(xxx, 0) rounds to the nearest integer
C7*24 converts your hh:mm to decimal hours (you need to format the cell to 0.00 to see the value)
*2 2 inspections per hour
HTH
dsm
#4
Posted 17 April 2007 - 07:35 AM
DSM you read my mind, Thanks a million.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users