|
|
11-26-2007, 11:33 PM
|
#31 |
|
Immortal
 
Location: helllllloooooo!!
Posts: 20,831
|
did you try it and make sure the A1 cell is formatted as time and entered as 9:30??? if it's after noon it can be entered as military time and the time format automatically converts it to AM and PM
|
|
|
11-26-2007, 11:47 PM
|
#32 |
|
Minion of Satan
 
Location: kicksville
Posts: 7,034
|
no.
i'm putting it in as military time. i know the TIMEVALUE function converts times in that format to a decimal between 0 and 1, which you can then multiply by 24 to get the number of hours past midnight. but i don't wanna do it that way. |
|
|
|
11-26-2007, 11:47 PM
|
#33 |
|
Rambling on
Posts: 20,548
|
|
|
|
|
11-26-2007, 11:49 PM
|
#34 |
|
Rambling on
Posts: 20,548
|
******'s gettin all grown up
 |
|
|
|
11-26-2007, 11:54 PM
|
#35 |
|
Immortal
Location: helllllloooooo!!
Posts: 20,831
|
well thats how excel WANTS you to convert times so have fun trying to figure out a back ass way
and thanks for being a complete jackass when I was trying to help you. you are an outstanding human being. |
|
|
|
11-26-2007, 11:55 PM
|
#36 | |
|
Just Hook it to My Veins!
 
Location: Planet Nintendu 64
Posts: 30,825
|
Quote:
|
|
|
|
|
11-26-2007, 11:57 PM
|
#37 | |
|
Minion of Satan
Location: kicksville
Posts: 7,034
|
Quote:
|
|
|
|
Linear Mode
