Time functions
 

I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and
in C1 column I enter the actual time like 13:00PM, that means he goes early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column he goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance

Time functions
 

How are you entering your time values... as shown (those are not not valid
time values then) or as real time values with a Cell Format set to display
what you have shown us? One problem with the time values (if you are
entering them as shown) is that a valid time value in Excel needs a space in
front of the AM or PM (you show no space). The second thing wrong with them
(again, assuming you are typing them in as shown) is that a 24-hour time
value (that is what the 13:00 part of your 13:00PM is) cannot have a PM
designation attached to it (with or without a separating space)... the fact
that it is greater than 12:00 PM tells you it is and afternoon time. Can you
clarify for us what you actually have for your time values?

--
Rick (MVP - Excel)


"srpavar" wrote in message
...
I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and
in C1 column I enter the actual time like 13:00PM, that means he goes
early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column he
goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance

Time functions
 

You don't say what the problem is.

Do you want the difference between actual and end time?

=B1-C1

--
__________________________________
HTH

Bob

"srpavar" wrote in message
...
I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and
in C1 column I enter the actual time like 13:00PM, that means he goes
early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column he
goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance

Time functions
 

Chip Pearson has an excellent tutorial with downloadable example on this
subject here 'Working With Times Example Page'
(http://www.cpearson.com/excel/overtime.htm)

srpavar;243704 Wrote:
I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time
and
in C1 column I enter the actual time like 13:00PM, that means he goes
early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column
he goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67952

Time functions
 

See your later posting. Please don't post the same question more than once.
--
David Biddulph

"srpavar" wrote in message
...
I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and
in C1 column I enter the actual time like 13:00PM, that means he goes
early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column he
goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance