Integer and time conversion

Hi Ron and welcome to the forum

I dont think your file attached properly?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

self-deleted duplicate post

I would guess that the problem comes from not understanding how Excel works with date/time values. From http://office.microsoft.com/en-us/ex...240.aspx?CTT=1

Microsoft Excel stores dates as sequential numbers that are called serial values. For example, in Microsoft Excel for Windows, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Excel stores times as decimal fractions because time is considered a portion of a day. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).

Because dates and times are values, they can be added, subtracted, and included in other calculations. You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.

So, assuming the 13:52 is a date/time serial value, the key to adding a value that is "# of minutes" is to convert that number into "fraction of a day." Then it should be easy enough to add the two date/time serials together. (comma delimited)

# of minutes,base time,fraction of a day,added to time
6,13:52,=A2/60/24,=C2+B2

format column D as time if you want it to show up as 13:58

If you want to add the minutes in column G to the time in column I you can use this formula.

Formula:

=I2+TIME(0,G2,0)

Ron

The TIME(h, m, s) worksheet function returns the time based on the (h)ours, (m)inutes and (s)econds you pass to it.

In this case we have no hours or seconds to just need to pass the minutes from G2.

Once we have the time we just add it.