software

Within 4 columns, I have a series of:
Start Dates / Start Times / End Dates / End Times
I need to create a formula which will give me the sum total of the
difference between the data sets.

For example, the time difference between 8am on the 20th March and 1pm
on the 21st March is 29 hours OR 1 day and 5 hours.
I need a formula which will calculate this for me.

I have driven the Paper Slide help function crazy by asking in numerous
ways how to do this and I've also searched the forums as well as asking
my resident Excel guy at work, but I cannot locate a solution.... Can
anyone help ??
Regards, Lea777--
Lea777
------------------------------------------------------------------------
Lea777's Profile: www.excelforum.com/member.php...oamp;userid=32692
View this thread: www.excelforum.com/showthread...hreadid=525103Start date in A2, start time in B2, end date in C2 and end time D2

03/20/06 in A2, 08:00 AM in B2, 03/21/06 in C2 and 01:00 PM

=(C2 D2)-(A2 B2)

format custom as [hh]:mm will return 29:00, format as d hh:mm will return 1
05:00

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Lea777quot; gt; wrote in
message ...
gt;
gt;
gt;
gt; Within 4 columns, I have a series of:
gt; Start Dates / Start Times / End Dates / End Times
gt; I need to create a formula which will give me the sum total of the
gt; difference between the data sets.
gt;
gt; For example, the time difference between 8am on the 20th March and 1pm
gt; on the 21st March is 29 hours OR 1 day and 5 hours.
gt; I need a formula which will calculate this for me.
gt;
gt; I have driven the Paper Slide help function crazy by asking in numerous
gt; ways how to do this and I've also searched the forums as well as asking
gt; my resident Excel guy at work, but I cannot locate a solution.... Can
gt; anyone help ??
gt; Regards, Lea777
gt;
gt;
gt; --
gt; Lea777
gt; ------------------------------------------------------------------------
gt; Lea777's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32692
gt; View this thread: www.excelforum.com/showthread...hreadid=525103
gt;I might add that if you need to calculate an hourly rate you need to
multiply the result with 24 then the rate

assume the formula is in F2

=F2*24*rate

format as currency

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Start date in A2, start time in B2, end date in C2 and end time D2
gt;
gt; 03/20/06 in A2, 08:00 AM in B2, 03/21/06 in C2 and 01:00 PM
gt;
gt; =(C2 D2)-(A2 B2)
gt;
gt; format custom as [hh]:mm will return 29:00, format as d hh:mm will return
gt; 1 05:00
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Lea777quot; gt; wrote in
gt; message ...
gt;gt;
gt;gt;
gt;gt;
gt;gt; Within 4 columns, I have a series of:
gt;gt; Start Dates / Start Times / End Dates / End Times
gt;gt; I need to create a formula which will give me the sum total of the
gt;gt; difference between the data sets.
gt;gt;
gt;gt; For example, the time difference between 8am on the 20th March and 1pm
gt;gt; on the 21st March is 29 hours OR 1 day and 5 hours.
gt;gt; I need a formula which will calculate this for me.
gt;gt;
gt;gt; I have driven the Paper Slide help function crazy by asking in numerous
gt;gt; ways how to do this and I've also searched the forums as well as asking
gt;gt; my resident Excel guy at work, but I cannot locate a solution.... Can
gt;gt; anyone help ??
gt;gt; Regards, Lea777
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Lea777
gt;gt; ------------------------------------------------------------------------
gt;gt; Lea777's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=32692
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=525103
gt;gt;
gt;Hi!

(End Date End Time) - (Start Date Start Time)

Format the cell as [h]:mm for a return of 29:00

((End Date End Time) - (Start Date Start Time))*24

Format the cell as GENERAL for a return of 29.

Biff

quot;Lea777quot; gt; wrote in
message ...
gt;
gt;
gt;
gt; Within 4 columns, I have a series of:
gt; Start Dates / Start Times / End Dates / End Times
gt; I need to create a formula which will give me the sum total of the
gt; difference between the data sets.
gt;
gt; For example, the time difference between 8am on the 20th March and 1pm
gt; on the 21st March is 29 hours OR 1 day and 5 hours.
gt; I need a formula which will calculate this for me.
gt;
gt; I have driven the Paper Slide help function crazy by asking in numerous
gt; ways how to do this and I've also searched the forums as well as asking
gt; my resident Excel guy at work, but I cannot locate a solution.... Can
gt; anyone help ??
gt; Regards, Lea777
gt;
gt;
gt; --
gt; Lea777
gt; ------------------------------------------------------------------------
gt; Lea777's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32692
gt; View this thread: www.excelforum.com/showthread...hreadid=525103
gt;

It worked guys, thank you so much,
Lea777
--
Lea777
------------------------------------------------------------------------
Lea777's Profile: www.excelforum.com/member.php...oamp;userid=32692
View this thread: www.excelforum.com/showthread...hreadid=525103
I have a different problem.I work in the BPO industry and I have an
excel spreasheet that keeps track of every agents time on call.I want a
spreadsheet column which will automatically display the current time
when the agent clicks on the cell.Then I need another column in which
the agents will click after they finish the call.And this cell should
automatically display the current time.I will then use the time
difference functions to calculate the time on call.Can anybody help ?--
harishkumar09
------------------------------------------------------------------------
harishkumar09's Profile: www.excelforum.com/member.php...oamp;userid=34826
View this thread: www.excelforum.com/showthread...hreadid=525103The current time can be entered by pressing quot;lt;controlgt; lt;shiftgt; ;quot;. To do it
by clicking on a cell would involve programming an event driven macro. You
could ask in the programming group.

--
Carlos

quot;harishkumar09quot; gt;
wrote in message
news:harishkumar09.28esu1_1148637608.3084@excelfor um-nospam.com...
gt;
gt; I have a different problem.I work in the BPO industry and I have an
gt; excel spreasheet that keeps track of every agents time on call.I want a
gt; spreadsheet column which will automatically display the current time
gt; when the agent clicks on the cell.Then I need another column in which
gt; the agents will click after they finish the call.And this cell should
gt; automatically display the current time.I will then use the time
gt; difference functions to calculate the time on call.Can anybody help ?
gt;
gt;
gt; --
gt; harishkumar09
gt; ------------------------------------------------------------------------
gt; harishkumar09's Profile:
www.excelforum.com/member.php...oamp;userid=34826
gt; View this thread: www.excelforum.com/showthread...hreadid=525103
gt;

Thanks Carlos.Let me also tell you we use Star Office in our workplace
and do the macros suggested in the programming section work for
StarOffice as well ?--
harishkumar09
------------------------------------------------------------------------
harishkumar09's Profile: www.excelforum.com/member.php...oamp;userid=34826
View this thread: www.excelforum.com/showthread...hreadid=525103Sorry, I don't know anything about star office.

--
Carlos

quot;harishkumar09quot; gt;
wrote in message
news:harishkumar09.28ge0b_1148711707.5054@excelfor um-nospam.com...
gt;
gt; Thanks Carlos.Let me also tell you we use Star Office in our workplace
gt; and do the macros suggested in the programming section work for
gt; StarOffice as well ?
gt;
gt;
gt; --
gt; harishkumar09
gt; ------------------------------------------------------------------------
gt; harishkumar09's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34826
gt; View this thread: www.excelforum.com/showthread...hreadid=525103
gt;

do any of you know where to get help for star office ?--
harishkumar09
------------------------------------------------------------------------
harishkumar09's Profile: www.excelforum.com/member.php...oamp;userid=34826
View this thread: www.excelforum.com/showthread...hreadid=525103