Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate time
hi
I want to make time sheet , when i am entering number eg: 10.00 & change in time format it shows 1/3/1900 12:00:00 AM. How do i get correct time in my cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate time
Type it with a COLON ":" instead of a period "."
sachin wrote: hi I want to make time sheet , when i am entering number eg: 10.00 & change in time format it shows 1/3/1900 12:00:00 AM. How do i get correct time in my cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate time
hi
first you must understand how excel keeps dates and time. dates are kept as a serial number in excel. we format this serial date to look like a date but todays date of 3/16/09(formated as date) is seen by excel as 39888 (formated as general) see this site for more detail on the 1900/1904 date keeping systme excel uses. http://support.microsoft.com/kb/214330 Time is kept by excel as a decimal value of a day. the decimal number of .75 (formated as general) is seen by excel as 6:00PM (formated as time) see this site for more info on this. http://support.microsoft.com/kb/214094 the site above also explains a lot of time keeping formulas that you might find useful. also it shows ways of converting decimals to time. regards FSt1 "sachin" wrote: hi I want to make time sheet , when i am entering number eg: 10.00 & change in time format it shows 1/3/1900 12:00:00 AM. How do i get correct time in my cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate from time started and finished to get total time used | Excel Worksheet Functions | |||
Calculate the duration between the end time and start time of anot | Excel Worksheet Functions | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) |