time table

G

Guest

I have a time table that I enter what time I come to work and what time I
leave. I didn't program it to add the total but when I put in total hours
worked "8" it puts in 0:00. When I double click to see if there is a setting
I get this 1/8/1900 12:00:00 AM I have tried to delete this but it still
shows up. What can I do to correct this problem? Thank you
 
G

Guest

Hi Mary,

your cell is format as hour, when you type 8 excel looks at Jan 8, 1900
12:00am, you can type 08:00 or format the cell as general

hth
regards from Brazil
Marcelo

"Mary" escreveu:
 
G

Guest

How do I get rid of the format as hours?

Marcelo said:
Hi Mary,

your cell is format as hour, when you type 8 excel looks at Jan 8, 1900
12:00am, you can type 08:00 or format the cell as general

hth
regards from Brazil
Marcelo

"Mary" escreveu:
Click to expand...
 

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

Time to Number Conversion 2
Excel Convert Datetime Stamp to HH and MM Worked 7
Help 13
Counting event times 5
excel time format 4
Time Sheets (Yes, I've already done a search on previous posts) 4
Calculate Face Time 4
Time Sheets 1

Top