calculating time

G

Guest

How do we calculate the difference in time in excel? For example, if we
enter 10pm in D2 and 7am in B2 we get some strange number regardless if the
cell is formated as a number or as a time. Does it need to be in 24 hour
time or what are we doing wrong??

Help please
 
G

Guest

tam25 said:
How do we calculate the difference in time in excel? For example, if we
enter 10pm in D2 and 7am in B2 we get some strange number regardless if the
cell is formated as a number or as a time. Does it need to be in 24 hour
time or what are we doing wrong??

Help please

This is a newsgroup for .NET programmers. I think that you have much
more luck with your question if you post it in a more relevant
newsgroup, like perhaps microsoft.public.excel.
 

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

Top