Summarizing Date and Time

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hello, I am trying to take the date in the format of mm/dd/yyyy hh/mm/ss and
on another worksheet creat a summary which would have a date field, a
seperate start time field, a seperate end time field, and a total time field.
Any suggestions as to the formulas that might help me out?

Thanks
 
If you want to create a date out of the date/time data you can use
this formula:
=DATE(YEAR(D7),MONTH(D7),DAY(D7))
and the time would be:
=TIME(HOUR(D7),MINUTE(D7),SECOND(D7))

When you have a second time value you can just use regular math (since
time is really just a decimal value in disguise) and add and subtract
as you need.
 
=INT(A2) gives the date.
=MOD(A2,1) gives the time.
Format the cells appropriately.

If you are doing time calculations and you want to display a total which is
more than 24 hours, format as [hh]:mm:ss, not hh:mm:ss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working with Date/Time 1
Date and Time Conversion 3
Date format problems after csv import 2
Format for making date calculations 4
date and time difference 19
convert a date 4
separating date and time 5
Date inconsistent help please :) 3

Back
Top