how do i calculate time

S

sachin

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?
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Bar - display of content 4
Excel Convert Datetime Stamp to HH and MM Worked 7
Calculate time worked 1
need help with look-up and time rage 4
Time Duration Calculation help needed 4
How do I calculate time in excel (clock in and clock out 3
Calculate the difference betwen two columns -two dates 3
pasting time from html 12

Top