formatting seconds to include commas

[fride360]

I'm using the following formula:

=NOW()-B4

"B4" is a date. Right now it formats just a row of numbers like "1234567890". I would like it to insert commas like "1,234,567,890"

Thanks

[AlKey]

Format cell: Custom, #,##0

[fride360]

When I format it like that the number doesn't come out right (as far as the qty. of seconds or minutes). I'm not sure if I need to include any other info from my spreadsheet or not. For instance if I use January 1, 2014 as an example there are 144,704 minutes and 8,682,273 second that has passed till today. The format of the cell is like [mm] for minutes and [ss] for seconds.

[AlKey]

A sample spreadsheet would help.

To upload a file click on Go Advanced on the bottom of your screen, then click on paperclip icon and Add Files.

[fride360]

Here is a sample. Hopefully it uploaded ok. Thanks

[AlKey]

So, per your example what your result will look like?

[fride360]

Instead of 144743 and 8684610 I would like commas in there like 144,743 and 8,684,610.

[shg]

	A	B	C	D
2	Date	01/01/2014
3	Minutes	144,732	B3: =(NOW()-B2)*1440	Format of B3: #,##0
4	Seconds	8,683,931	B4: =(NOW()-B2)*86400

[AlKey]

or you can do it in one formula

=TEXT((NOW()-A3)*1440,"#,##0")

=TEXT((NOW()-A3)*86400,"#,##0")

[fride360]

I'm trying to understand the formula. Why is it multiplied by 1440 and 86400?
Thanks

[AlKey]

You can read about it here

https://answers.yahoo.com/question/i...2064405AAwualy

[AlKey]

Thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).