How do you get 8 from 5? I take it the 8 isn't actually a minute value?
I need a simple formula to convert standard time (1:05pm) into military time (13:08).
I've read through several posts, but all I've found is reformatting or time subtraction type information. The reformating works to an extent, it gives me the hours in military but the minutes stay standard.
Basicly, all I need is:
Cell A1 = 1:05 p
Cell B1 = formula that shows/converts 1:05 p as 13:08
Can someone direct me to a helpful post or help me with this?
When you do that calculation, you end up with a decimal value (ie it is not Excel time). You just need to amend to an appropriate number format eg Format>Cells>Number Tab, Custom Category and the 0.00 option, for example.
There are currently 1 users browsing this thread. (0 members and 1 guests)