Total Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LMB - 16 Sep 2004 21:17 GMT

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

Reply to this Message

JE McGimpsey - 16 Sep 2004 21:24 GMT

=MOD(B1-A1,1)

> Hi Guys,
>
[quoted text clipped - 5 lines]
> Thanks,
> Linda

Reply to this Message

LMB - 16 Sep 2004 22:47 GMT

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)

In article <uHVj2oCnEHA.3196@TK2MSFTNGP10.phx.gbl>,
"LMB" <RomulanQueen@10Forward.SSTNG> wrote:

> 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

Reply to this Message

JE McGimpsey - 16 Sep 2004 22:58 GMT

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*

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

Reply to this Message

LMB - 18 Sep 2004 15:36 GMT

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*

In article <#pBQTbDnEHA.648@tk2msftngp13.phx.gbl>,
"LMB" <RomulanQueen@10Forward.SSTNG> wrote:

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

Reply to this Message