Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time into a number
Could you please tell how I could do the following
Cell A2 has 4:00 and I would like to see in B2 the number 4 In the same manner if A2 has 4:30 then B2 should show the number 4.5 I appreciate anyone's help. -- Many Thanks. Warmest Regards, Polochilde |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time into a number
=(A2-INT(A2))*24
Put in B2 should work. Mike "Polochilde" wrote: Could you please tell how I could do the following Cell A2 has 4:00 and I would like to see in B2 the number 4 In the same manner if A2 has 4:30 then B2 should show the number 4.5 I appreciate anyone's help. -- Many Thanks. Warmest Regards, Polochilde |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
time into a number
Hi
Why not just: =A2*24 Jean-Guy "Mike" wrote: =(A2-INT(A2))*24 Put in B2 should work. Mike "Polochilde" wrote: Could you please tell how I could do the following Cell A2 has 4:00 and I would like to see in B2 the number 4 In the same manner if A2 has 4:30 then B2 should show the number 4.5 I appreciate anyone's help. -- Many Thanks. Warmest Regards, Polochilde |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you but still does not work -time into a number
Dear Mike and Pinmaster,
Thank you so much for the reply. Your formula keeps giving me 0:00 Too be clear if 4:00 (11:00am - 0700am) and then your formula in the next cell still does not turn time difference into a number. I appreciate your help. -- Many Thanks. Warmest Regards, "Mike" wrote: =(A2-INT(A2))*24 Put in B2 should work. Mike "Polochilde" wrote: Could you please tell how I could do the following Cell A2 has 4:00 and I would like to see in B2 the number 4 In the same manner if A2 has 4:30 then B2 should show the number 4.5 I appreciate anyone's help. -- Many Thanks. Warmest Regards, Polochilde |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you but still does not work -time into a number
Hi,
Format the cell as General or Number and you should be ok. Cheers! Jean-Guy "Polochilde" wrote: Dear Mike and Pinmaster, Thank you so much for the reply. Your formula keeps giving me 0:00 Too be clear if 4:00 (11:00am - 0700am) and then your formula in the next cell still does not turn time difference into a number. I appreciate your help. -- Many Thanks. Warmest Regards, "Mike" wrote: =(A2-INT(A2))*24 Put in B2 should work. Mike "Polochilde" wrote: Could you please tell how I could do the following Cell A2 has 4:00 and I would like to see in B2 the number 4 In the same manner if A2 has 4:30 then B2 should show the number 4.5 I appreciate anyone's help. -- Many Thanks. Warmest Regards, Polochilde |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you but still does not work -time into a number
Maybe your times are not real times?
Did you enter as 11:00 and 7:00 Where are they entered? In A3 enter 11:30 In A4 enter 7:00 In A2 enter =A3-A4 which returns 4:30 In B2 enter the formula =(A2-INT(A2))*24 which returns 4.5 Gord Dibben MS Excel MVP On Sun, 4 Mar 2007 12:36:17 -0800, Polochilde wrote: Dear Mike and Pinmaster, Thank you so much for the reply. Your formula keeps giving me 0:00 Too be clear if 4:00 (11:00am - 0700am) and then your formula in the next cell still does not turn time difference into a number. I appreciate your help. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you Mike, Pinmaster and Gord Dibben
Thank you to alll of you it works
-- Many Thanks. Warmest Regards, "Gord Dibben" wrote: Maybe your times are not real times? Did you enter as 11:00 and 7:00 Where are they entered? In A3 enter 11:30 In A4 enter 7:00 In A2 enter =A3-A4 which returns 4:30 In B2 enter the formula =(A2-INT(A2))*24 which returns 4.5 Gord Dibben MS Excel MVP On Sun, 4 Mar 2007 12:36:17 -0800, Polochilde wrote: Dear Mike and Pinmaster, Thank you so much for the reply. Your formula keeps giving me 0:00 Too be clear if 4:00 (11:00am - 0700am) and then your formula in the next cell still does not turn time difference into a number. I appreciate your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
Formula Help - Number to Time | Setting up and Configuration of Excel | |||
Converting whole number to TIME | Excel Discussion (Misc queries) | |||
Time as number | Excel Discussion (Misc queries) | |||
Time to number | Excel Worksheet Functions |