Total Time

[LMB]

Hi Guys,

I thought this would be in the old posts but I am running out of time to look so...sorry if this is already posted somewhere. I have cell A1 with my start time, B1 has my finish time. Both are formatted in military time. I want cell C1 to show how many hours I worked. What would the formula be?

Thanks,
Linda

 

[JE McGimpsey]

=MOD(B1-A1,1)

 

[LMB]

Thanks! What does MOD mean and how would a regular person figure this out? Is there a place that tells what the different functions mean?

Linda

=MOD(B1-A1,1)

 

[JE McGimpsey]

Sorry - I ran out of time to answer...Take a look at Help.

You can also look in the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*

 

[LMB]

I looked through the help and it seems like the best thing to do for a regular person is to ask this group! <g>
I saved that search site...I found the answer to another question there.

Thanks,
Linda
Sorry - I ran out of time to answer...Take a look at Help.

You can also look in the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*