timesheet functions
 

I have setup my own time sheet and initially did most of the calculations in
my head besides the hours for the day sum and then a total of all those using
the sum function.

What I would like to do is to be able to have a start time and end time
column and excel to calculate the time elapsed between those values and round
to quarter hours. How do I do this?

timesheet functions
 

Hi Darren,
check this web it has all the answers related with time elapsed

http://www.cpearson.com/excel/datetime.htm

If this was helpful please say yes, thanks

"Darren" wrote:

I have setup my own time sheet and initially did most of the calculations in
my head besides the hours for the day sum and then a total of all those using
the sum function.

What I would like to do is to be able to have a start time and end time
column and excel to calculate the time elapsed between those values and round
to quarter hours. How do I do this?

timesheet functions
 

Give this formula a try...

=MROUND(24*(A2-A1),0.25)

Note: This formula requires you to activate the Analysis ToolPak in order
for it to work (Tools/Add-In on the menu bar).

--
Rick (MVP - Excel)


"Eduardo" wrote in message
...
Hi Darren,
check this web it has all the answers related with time elapsed

http://www.cpearson.com/excel/datetime.htm

If this was helpful please say yes, thanks

"Darren" wrote:

I have setup my own time sheet and initially did most of the calculations
in
my head besides the hours for the day sum and then a total of all those
using
the sum function.

What I would like to do is to be able to have a start time and end time
column and excel to calculate the time elapsed between those values and
round
to quarter hours. How do I do this?