6.24 is a decimal in unit "hours".
5:58:16 is a number in in unit "days" because all dates and times in all
spreadsheets are days. The unformatted value might be close to 0.25 because
6 hours are 1/4 of a day. REMOVE THE FORMAT AND SEE.
Convert your hours to days and add it to the other days.
=A
So if I'm getting this right, I would just do something like this:
A B
1 Last Call: 5:58:16
2 Duration: 6.24
Total:: =B1 + B2 (and format as needed)
On 4/6/2016 8:07 AM, Andreas Säger wrote:
Am 06.04.2016 um 15:36 schrieb John Meyer:
Hi,
I have a project wh
Am 06.04.2016 um 19:27 schrieb James Knott:
>
> While I haven't done this in a spreadsheet, I used to on a calculator.
> I did it by converting between decimal degrees and degrees, minutes &
> seconds.
>
> BTW, as an indication of how long ago I did this, I used this method to
> add up the time
Am 06.04.2016 um 15:36 schrieb John Meyer:
> Hi,
>
> I have a project where I am trying to calculate the total amount of work
> hours for a project based upon the timestamp of calls throughout the
> day. The time at which the calls is placed is in hh:mm:ss while the
> duration of the call is in d