CODEWITHSUNDEEP
excel
LENBERT88
LENBERT88

Reputation: 21

formula to minutes and seconds down into total amount in seconds

I am looking a formula for excel that minus a feild called end time by field start time and answer will show as the total amount of seconds the calls lasted.

For example i have call that ended 04:04:35 and started at 03:51:51 and i need to how many seconds that would be in total and instead of working by calucator would like to know if there fourmula to do it

thanks simon

Upvotes: 0

Views: 237

Answers (1)

er_tomas
er_tomas

Reputation: 59

The easiest is to set the two cells as time (hh:mm:ss) then subtract them.

Put the result on a new cell, formatted as a number and multiply the result by 86400.

See this post for the explanation

EDIT: the final cell has to be in number format, something like this:

                      A         B             C
 Cells        1    03:51:51  04:04:35  =(B1-A1)*86400
 Cell format:      hh:mm:ss  hh:mm:ss       number

Upvotes: 4

Related Questions