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? |
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? |
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? |
All times are GMT +1. The time now is 03:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com